Search results for query: *

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...

Even IF it does affect performance (which it is not), comments must still be used. Nobody wants to inherit huge lines of code without a single trace of comments. Simple things like date, number of updates, who's doing the update, reason for update, etc etc will greatly help. Example: people...

Thanks for such a quick reply. Well, seems like in this part of the world some people still find it too expensive to transfer considerable amount of data through the jolly-olde telephone line. Just trying to give my dear client more options, man. :) And for your suggestion, sorry, both servers...

Hi, I've been successfully (at home) set up a merge replication, i.e. 1. set up a publisher, 2. create publications, 3. set up subscribers, 4. set up subscriptions, 5. initialize subscriptions with snapshots 6. synchronize publisher and subscribers But in order to do step 3, 4, 5 and 6...

Hi, I've been successfully (at home) set up a merge replication, i.e. 1. set up a publisher, 2. create publications, 3. set up subscribers, 4. set up subscriptions, 5. initialize subscriptions with snapshots 6. synchronize publisher and subscribers But in order to do step 3, 4, 5 and 6...

Hi, I'm using BDE on Delphi 7, but I believe the TDatabase main methods and properties remain very much the same. Using BDE, (officially) you can connect to MS Access .mdb files using one of these drivers: - MSACCESS (Delphi native driver) - Microsoft Access Driver (*.mdb) (ODBC) Apparently...