Print Page - Database reference

Title: Database reference
Post by: Rock Ridge Farm (Larry) on March 28, 2006, 03:04:27 PM

What would be a good thing to read about syntax for database commands.
I found the error codes on-line but would like to find a reference manual.

Title: Re: Database reference
Post by: Rock Ridge Farm (Larry) on March 30, 2006, 11:32:50 AM

I have tracked down my issue - it is related to date fields. I have the field declared
as a string in Aurora - seems to work except it appends the time to the field.
When I look in the database it is just a date.
This database thing is running me (more) crazy.
Is there a good reference on MDB?

Title: Re: Database reference
Post by: Ionic Wind Support Team on March 30, 2006, 12:05:37 PM

Use the BindDate funciton instead with a DBDATE structure variables. Then format the date as you see fit.

Title: Re: Database reference
Post by: Rock Ridge Farm (Larry) on March 30, 2006, 12:27:38 PM

Where can I find a reference that would tell me about things like BindDate?
There has to be a book or manual somewhere.

Title: Re: Database reference
Post by: Ionic Wind Support Team on March 30, 2006, 12:39:44 PM

The database class is my own design. BindDate uses the ODBC API funciton SQLBindCol with SQL_C_DATE as the type of data. You can read the database manual that came with IBasic Pro for a general idea as the functionality is the same.

Title: Re: Database reference
Post by: Rock Ridge Farm (Larry) on March 30, 2006, 01:42:50 PM

I do not have that manual. I bought the gold cd and did not find any documentation
about the database addon. Anyone got a copy I can borrow :)

Title: Re: Database reference
Post by: Parker on March 30, 2006, 01:56:24 PM

http://www.pyxia.com/index.php?option=com_remository&Itemid=34&func=selectfolder&filecatid=11

Title: Re: Database reference
Post by: Ionic Wind Support Team on March 30, 2006, 02:09:04 PM

It's also on the help menu, if you installed it from the gold CD

Title: Re: Database reference
Post by: Rock Ridge Farm (Larry) on March 30, 2006, 05:28:25 PM

Thanks - that is what I was looking for.

IonicWind Software

Aurora Compiler => Database => Topic started by: Rock Ridge Farm (Larry) on March 28, 2006, 03:04:27 PM