Jump to content


jiaseby

Member Since 13 Dec 2016
Offline Last Active Dec 08 2017 03:15 AM

Topics I've Started

Different Dialogic Cards

08 December 2017 - 03:17 AM

Can I use 2 different Dialogic 4 port cards on one machine to have 8 lines?  Or do they have to be the exact same model?


Blank Date Field

27 December 2016 - 04:44 AM

I'm pulling data from a table that is a date field.  I want to test if the field has a date in it or not.  It is a table with check information.  One of the fields is "Cleared".  If it is blank that means the check is still outstanding.  However when I look at the field I see it has a date in it when it's blank.  The date is 12/30/1899 12:00:00 AM.  Can you tell how I test for this?  It is the data in SQLCheck_4_1 in the engine log attached.

 

 


Adding Days To A Date Field

21 December 2016 - 03:55 AM

After I query a database and get a field that is a date field, I need to add 14 days to it.  Not sure how to do this.  I'm guessing in an evaluate expression, but I'm having no luck.


Sql

16 December 2016 - 08:46 AM

I'm trying to do a insert into a table.  I need to store a date field.  What is the best way to get the date from Voiceguide that will work in the insert sql command?


Odbc Connection

13 December 2016 - 08:53 AM

I'm trying to create a script where I can query a Visual Foxpro table with an ODBC Connection and the Query Database function.  I emailed support and they suggested I post with a sample of the table zipped up.  

 

This is the copy of the email I sent them.

 

ODBC question.

I have a client that has a Visual Foxpro Database.  I’ve created an odbc connection and am trying to run a “Query Database” on it to test retrieving data.  I’m not sure what should go in the three fields.  The odbc name is “Check”.  It is a table that has 3 fields, they are check,amount,iussed.  In other words check number, amount and issue date.  I wanted to do a very basic Sql query and say the amount.  So I’m guessing I could say “Select check, amount,issued from check where check=’1’.  It fails every time.  I’m guessing because I didn’t put anything in the two previous fields.  I’m not sure what goes in the fields ADO.NET or Connection string.  Any help would be greatly appreciated.