Zeoslib Portal

btrewern

If you just want to insert into a table use a TZQuery with a

select * from newsy WHERE 1 = 0;

as your SQL. You don't even download one record and it works with any server.

Regards,

Ben

btrewern

Cezar, Other possible solution: don't use TZTable. :wink: I've always been told not to use TTable or similar components when using RDBMSs for just this very reason. It may be that some TDataset descendants use a cursor or similar to page through the data returned from the server, but Zeos has never ...

btrewern

For the field in question set
Required := False;
that should do the trick.

Regards,

Ben

btrewern

Does what work? What are you trying to achieve?

If you keep doing

Code: Select all

SELECT currval('seq_name');

you will keep getting the same answer (as these value are cached per connection). If you keep doing

Code: Select all

SELECT max(id) FROM table_name;

every 1ms you will just cause lots of network traffic.

Regards,

Ben

btrewern

Hudgi, FYI the currval() function is safe for doing things like this and should not cause race conditions. From the PostgreSQL docs: currval Return the value most recently obtained by nextval for this sequence in the current session. (An error is reported if nextval has never been called for this se...

btrewern

Mark,

In PostgreSQL there is the PQescapeStringConn function which I think does what you are looking for from a PostgreSQL point of view.

See here:
http://www.postgresql.org/docs/8.2/stat ... APE-STRING

Introduced in PostgreSQL 7.3.

Regards,

Ben

btrewern

Which is the oldest version of PostgreSQL that Zeos supports?

Schemas came in at 7.3 so you may need to make the query version dependent.

Ben

btrewern

I can't seem to find anywhere that decisively marks a field as a serial field (similar to AUTO_INCREMENT in MySQL speak). But you can use something like SELECT column_default FROM information_schema.columns WHERE table_schema = 'schema' AND table_name = 'table_name' AND column_name = 'column_name' T...

btrewern

You can use the LAST_INSERT_ID() SQL function in MySQL.

Regards,

Ben

btrewern

Try

Code: Select all

SELECT lanname,   regproc(lanpltrusted,lanplcallfoid) AS lanplcallf  FROM pg_language WHERE lanispl ORDER BY lanname;

Regards,

Ben

btrewern

If you are using a (very) new version of PostgreSQL (not sure if it's 8.1 or 8.2 but) you can use the multiple rows version of INSERT. example from the Postgresql docs: INSERT INTO products (product_no, name, price) VALUES (1, 'Cheese', 9.99), (2, 'Bread', 1.99), (3, 'Milk', 2.99); This should be fa...

btrewern

You'll need the following dlls in your path:

comerr32.dll
iconv.dll
krb5_32.dll
libeay32.dll
libiconv-2.dll
libintl-2.dll
libpq.dll
ssleay32.dll

You can find these in your pgAdmin III program folder.

Regards,

Ben

btrewern

The RequestLive property was replaced by ReadOnly. Just ignore the error.

Regards,

Ben

btrewern

I seem to remember this has something to do with Zeos being run against the wrong dll. Try to make sure that the dlls supplied along with Zeos in the lib\mysql folder are used ie put them in the application or system32 folder.

Regards,

Ben

btrewern

Does this work if you do the ordering in the dataset?

Try setting to SortedFields to the field you want to order by.

Hope this helps.

Regards,

Ben

Search found 193 matches