July 04, 2022, 03:41:18 AM

News:

IonicWind Snippit Manager 2.xx Released!  Install it on a memory stick and take it with you!  With or without IWBasic!


Database reference

Started by Rock Ridge Farm (Larry), March 28, 2006, 03:04:27 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Rock Ridge Farm (Larry)

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.

Rock Ridge Farm (Larry)

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?

Ionic Wind Support Team

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

Rock Ridge Farm (Larry)

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

Ionic Wind Support Team

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.

Ionic Wind Support Team

Rock Ridge Farm (Larry)

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 :)


Ionic Wind Support Team

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

Rock Ridge Farm (Larry)

Thanks - that is what I was looking for.