Recent content by ndaru

And stay away from ODBC. Use native MySQL drivers. www.freetechbooks.com

True. If you use TQuery.RecordCount, it will always return -1. RecordCount method only works with a TTable instance connected with file-based database like Paradox. (That's what I've found in Delphi 3,5,7. I haven't tested it on Delphi 2007). www.freetechbooks.com

IMO, the best MySQL access component is Core Lab MySQL (which costs $79.95 to $349.95). It's fast, with small footprint, compatible with BDE with components that mimic the interfaces and functions of BDE's components (TQuery, TDataSource, and TUpdateSQL) for easy migration. The end product will...

You can only reverse-engine the forms but not source code. But that's the case with Delphi 3 and 5. I don't know about the rest (never have the need to find out), but I think it's still the same. Otherwise, everyone will reverse-engine your .exe and that would be undesirable. :p...

ZeosLib component is OK for connecting to MySQL and several other database standards. The downside is, ZeosLib tries to be as compatible as possible with several DB standards at once. Hence it's not recommended if you need to use a certain features that only exist on a certain DB standard. Then...

Have you consider to use a direct connection to MySQL server using drivers other than ODBC? Direct connection is (always) better than ODBC. The price tag for Delphi 7 Enterprise and non-Enterprise differs so much, because the former includes SQLLink to connect to MSSQLServer, while the latter...

Try: Query1.ParamByName('param').Clear; similarly, for the fields: Query1.FieldByName('field').Clear; www.freetechbooks.com

I also recently encountered the same problem. We have two projects, each one using different component. Yet both components are mutually exclusive. At this moment the temporary solution is just like you. All I can do is write a batch file (.bat) to automate the copy/delete process. Maybe there...

Thanks George, I'll give it a try. Ndaru www.freetechbooks.com

I use this setup.ini file to install MSDE 2000, and it's always work: [Options] TARGETDIR=c:\Program Files\MYDB\ DATADIR=c:\Program Files\MYDB\ INSTANCENAME=MYINSTANCE DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL BLANKSAPWD=1 Problem is, I couldn't figure out how to put password in the setup.ini...

Wow, my mistake. Thanks, SQLDenis. Superb. www.freetechbooks.com

About time. I still hope they will put back the virtual support for GNU/Linux. www.freetechbooks.com

To get the latest AVG updates, visit: http://free.grisoft.com/doc/24/lng/us/tpl/v5 www.freetechbooks.com

Have you tried to press F5 immediately after booting to enter Safe mode? www.freetechbooks.com

I think ashley75 is looking for an MS SQL Server book that freely available online. I haven't yet find a freely available MS SQL Server book (a legal one of course, not the pirated ones). There are many free (and legal) computer books available online, but free books for popular and profitable...