Page 1 of 1
Posted: Sun Dec 29, 2002 10:14 pm
by BackupUser
Restored from previous forum. Originally posted by Fangbeast.
Is there anyone who uses Purebasic to write to access databases regularly who could give me some examples of the RIGHT way to set it up and the limits and syntax?
I wrote a small Application called DeBased which does this (On Paul's site) but I am coming up against limitations and other problems which are certainly not covered in the SQL tutorials that I went into.
A frustrated fang.
Fangles woz ear orright den?
Posted: Mon Dec 30, 2002 10:02 am
by BackupUser
Restored from previous forum. Originally posted by Manolo.
Hi Fang,
I recomended you the next book: Teach Yourself MySQL in 21 Days, from Mark Maslakopwski.
ISBN: 0-672-31914-4
This book have examples in the book and CD for read in Access and Write in MySQL via ODBC and another databases (All time via ODBC).
Is very best that others SQL tutorials.
Regards,
Manolo
Posted: Mon Dec 30, 2002 12:00 pm
by BackupUser
Restored from previous forum. Originally posted by Fangbeast.
Originally posted by Manolo
Hi Fang,
I recomended you the next book: Teach Yourself MySQL in 21 Days, from Mark Maslakopwski.
ISBN: 0-672-31914-4
This book have examples in the book and CD for read in Access and Write in MySQL via ODBC and another databases (All time via ODBC).
Is very best that others SQL tutorials.
Regards,
Manolo
Thanks manolo, if I can scrape some dollars together, I will do that. Been hurting my eyes going through translation tables on MSDN because what you type in SQL is not what ACCESS sees.
I.e using field text(20) in sql (in purebasic) is translated to char(20) for Access, varchar(20) for foxpro and ntext(20) for jet.
I am not even sure of that!!!
Regards
Fangles woz ear orright den?
Posted: Mon Dec 30, 2002 4:26 pm
by BackupUser
Restored from previous forum. Originally posted by Manolo.
Yes Fang, but the problem is in ODBC drivers, not in PB commands (I think).
If you want more of MySQL and PB commands, please, see Feature Requests and Wishlists from my and Num3 (Is one request for Fred). Num3 and I, will see the maner of make and built one system for direct acces to MySQL without ODBC. Need help of experts in databases.
Regards.
Manolo (Sorry for bad english)
Posted: Mon Dec 30, 2002 9:48 pm
by BackupUser
Restored from previous forum. Originally posted by Fangbeast.
Originally posted by Manolo
Yes Fang, but the problem is in ODBC drivers, not in PB commands (I think).
If you want more of MySQL and PB commands, please, see Feature Requests and Wishlists from my and Num3 (Is one request for Fred). Num3 and I, will see the maner of make and built one system for direct acces to MySQL without ODBC. Need help of experts in databases.
Regards.
Manolo (Sorry for bad english)
That's right, I found that out after many hours of searching MSDN for ODBC translation and must have tried every translation I could think of. Next trick is to find a driver and take it apart to see what it has stored in the way of keywords
Fangles woz ear orright den?