Search found 35 matches
- 18.12.2011, 15:55
- Forum: 6.6 - stable
- Topic: How to Handle AutoIncs (or SERIALS in Postgres)
- Replies: 3
- Views: 776
How to use this component? Seem self-explanatory but I do not want to manage sequences on the application. The sequences are automatically executed on the DATABASE. So, the TZSequencev does what? 1. Exposes the PG Sequence to the Zeos componentes use it? or 2. Executes the PG Sequence, get the resul...
- 17.12.2011, 22:18
- Forum: PostgreSQL
- Topic: Postgres + doCalcDefaults + Bigserial Column = 2 on 2 seq.!
- Replies: 27
- Views: 8149
- 17.11.2011, 05:49
- Forum: PostgreSQL
- Topic: Postgres + doCalcDefaults + Bigserial Column = 2 on 2 seq.!
- Replies: 27
- Views: 8149
- 03.11.2011, 03:03
- Forum: PostgreSQL
- Topic: Postgres + doCalcDefaults + Bigserial Column = 2 on 2 seq.!
- Replies: 27
- Views: 8149
Postgres + doCalcDefaults + Bigserial Column = 2 on 2 seq.!
Hello Everybody! I'll be direct on my post... I'm using now the PostgreSQL database. I'm using BIGSERIAL columns, to take advantage of sequences to primary keys. This is very usual, i guess. So, I've done a little application to test this behaviour. Everything was fine, except that my primary key co...
- 15.08.2011, 14:22
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Oracle 10.2 problem to connect
- Replies: 8
- Views: 2499
O instant Client, é sempre necessário no computador que vai fazer acesso ao oracle, porque ele além de outros dlls contém o principal dll de todos, OCI.DLL. No entanto eu não aconselho usar o instalador do Instant Client mas sim suas versões zipadas que precisam ser manualmente configuradas: http://...
- 15.08.2011, 14:16
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Oracle 10.2 problem to connect
- Replies: 8
- Views: 2499
- 15.08.2011, 14:15
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Oracle 10.2 problem to connect
- Replies: 8
- Views: 2499
- 12.08.2011, 16:12
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Oracle 10.2 problem to connect
- Replies: 8
- Views: 2499
Pelo seu nome você deve entender português... :) A solução que você apresentou eu já havia tentado, o erro está no próprio zeos. Existe um procedimento (o qual não recordo agora) que faz uso de uma função contida em OCI.dll e serve para conectar ao banco de dados. O que acontece é que a classe que i...
- 07.07.2011, 21:43
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Oracle 10.2 problem to connect
- Replies: 8
- Views: 2499
Oracle 10.2 problem to connect
Hello everybody, I'm having problems to connect with oracle database on my work. I will go straight to the question My TNSNAMES.ORA is: ORAPROD.WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 191.168.1.202)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORAPROD) ) ) ORADES...
- 08.09.2009, 12:51
- Forum: MySQL
- Topic: MYSQL AUTOREFRESH
- Replies: 5
- Views: 1788
Ðerek , It's fine to help people in portuguese, but the condition is that you give at least a summary in english for those poor forum visitors who don't understand your universal language. Mark Sorry... AGAIN... The sollution was to pay attention at the transact Isolation Level and the way to do th...
- 08.09.2009, 12:46
- Forum: MySQL
- Topic: Uniquely Indexed Column Problem
- Replies: 5
- Views: 482
- 04.09.2009, 17:11
- Forum: MySQL
- Topic: MYSQL AUTOREFRESH
- Replies: 5
- Views: 1788
Re: MYSQL AUTOREFRESH
when i update a record in one station, i can't see this update or insert in a second machine. There is an automatic way to update de information inserted/edited in another machine? I tried: tztable.refresh.... after scroll event... but it hangs... Thanks. Olá! Você tem de ver o nível de isolamento ...
- 03.09.2009, 19:09
- Forum: MySQL
- Topic: Uniquely Indexed Column Problem
- Replies: 5
- Views: 482
- 03.09.2009, 15:13
- Forum: MySQL
- Topic: Uniquely Indexed Column Problem
- Replies: 5
- Views: 482
- 01.09.2009, 13:52
- Forum: MySQL
- Topic: Uniquely Indexed Column Problem
- Replies: 5
- Views: 482
Uniquely Indexed Column Problem
Hello everybody! Recently i figure with a strange problem... I have a form with a grid and some DBEdits. I have ZConnection, ZQuery, DataSource and a ZUpdateSQL. Everything is correctly linked, and all data types on the persistent fields (on ZQuery) are correct... The table structure is CREATE TABLE...