Search found 68 matches

by Pitfiend
17.02.2010, 18:51
Forum: 6.6 - stable
Topic: Field x is required, But not supplied.
Replies: 7
Views: 1238

Can you put the sql query in the zquery? Sometimes that happens when you misspell anything in the sql definition, that it's taken as a field, resulting in that weird error.
by Pitfiend
11.02.2010, 20:01
Forum: 6.6 - stable
Topic: MYSQL - Binary Data, writing to Varbinary or Varchar
Replies: 3
Views: 2201

Depending on how much crypted data you want to store, maybe you can give a shot to this crypting method (look at the last post) http://www.afterwarp.net/forum/thread460-3.html. They claim that it is very fast and optimized routines, with little footprint.
by Pitfiend
28.01.2010, 06:49
Forum: 6.6 - stable
Topic: Multiple threds accessing single TZquery object
Replies: 3
Views: 637

Advanced Knitting...

Because working with threads implies you need to knit some stuff, I'll share with you a bit of usefull knowledge. Maybe it can helps you to get your stuff to work better.
by Pitfiend
20.01.2010, 05:38
Forum: 6.6 - stable
Topic: Libraries for lipq.dll and libpq81.dll cannot be found
Replies: 8
Views: 5182

I'm not really sure about, but I think you need to provide the dll in the system search path or in the same directory as your application.

When I try the mysql ones, I did that and all runs fine. Just provide the right ones for you case and db.
by Pitfiend
20.01.2010, 05:23
Forum: 6.6 - stable
Topic: Database creation issues
Replies: 4
Views: 1285

Hey guys... it will be nice if someone else contribute with his knowledge. Being part of a community means to share with it.
by Pitfiend
17.12.2009, 22:50
Forum: 6.6 - stable
Topic: execSQL with POSTGRESQL
Replies: 4
Views: 659

After my previous experience using queries, I can tell that you need to close, clear, assign new command to SQL property, and then call ExecSQL for anything else than a SELECT command. Because they didn't return record sets to be shown, only the number of affected rows. When you send a SELECT comman...
by Pitfiend
15.12.2009, 04:33
Forum: 6.6 - stable
Topic: Database creation issues
Replies: 4
Views: 1285

Nice, thanks. Anyone else can contribute with the others? What I'm looking for, is the creation of MS Access using ADO driver. If anyone want to create a SQLite database, here's how (again Connection is a TZConnection object): Connection.Protocol:='sqlite-3'; Connection.Database:='C:\Database.sqlite...
by Pitfiend
12.12.2009, 07:53
Forum: 6.6 - stable
Topic: Database creation issues
Replies: 4
Views: 1285

Database creation issues

I was using this amazing component library to build many of my recents projects. In earlier development stages, I was wondering if it is possible to create databases directly using the Zeos components to enable my applications to be distribute in easier ways for my users. I was looking into the foru...