Zeoslib Portal

One more trick: If you want, you can use table fieldnames to get what you need. Example:

Query1.FieldByName('FIRST_NAME').AsString := 'Hohoho';

Ah, and finally: Have a nice and successfull 2007!! (This is dedicated to all!)

regular = TTable + BDE + ODBC As said: Ugly, slow, but usually worx for one-tme projects ..

Try to access it via ODBC (latest of course) and "regular" datasets (like old,slow, ugly BDE)

Sorry, don't understand... SQL as itself is a string that descripts the values to be inserted. Example, please.

Anytime.. Hope it will work OK (never tried between different database types).

I would try to do it by 4 methods 1. Via MySQL GUI tool for data migration - I tried it once and it worked quite well (few, nonrelevant errors). Definitely worth a try. 2. Via SQL export. I'm not an MSSQL expert, but if there's a SQL export option, use it. And if (well, chances are quite low here) t...

Good luck!

If you need more help, just post here

I still use the good-old-fashioned "Select Count(*) From TABLE" instead of RecordCount.. (of course, where it is possible to do this).

Using MySQL for latest 4 yeary - totally happy withe it. About your questions: MyISAM is OK. InnoDb is better for transactions, foregn keys, table/row locking and (in some cases) for stored procedures. I use both engines - except for speed the usage is practically identical. I reccomend you MyISAM f...

What about triggers? This way you can post into a table and the server will process the data in a secure way.

Hmmm.. true, but aren't functions usually called within the Call command, not via Select?

Use a TZQuery - see above.

Another trick is to select as many columns as you can: Instead of

Select * From TBL1

Try to use

Select FLD1,FLD2 From TBL1

It can drammatically improve speed.

I agree with mdaems - it's a very risky practice.
Suggestion: Make a table prefix, for example "tbl1" or "application1"... etc.

SHOW TABLES FROM 99 LIKE 'clientes'

Should be

SHOW TABLES FROM `99` LIKE 'clientes'