Search found 35 matches

by Ðerek wildstar
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...
by Ðerek wildstar
17.12.2011, 22:18
Forum: PostgreSQL
Topic: Postgres + doCalcDefaults + Bigserial Column = 2 on 2 seq.!
Replies: 27
Views: 8149

Sorry for UP... Well I'm not using two components only one. The last paragraph is very explanatory. I will complete it: Doing a debug i found that TZGenericCachedResolver.FormCalculateStatement is generating a SQL with the default value of my bigserial column. Something like "SELECT NEXTVAL(COL...
by Ðerek wildstar
17.11.2011, 05:49
Forum: PostgreSQL
Topic: Postgres + doCalcDefaults + Bigserial Column = 2 on 2 seq.!
Replies: 27
Views: 8149

Sorry, but UP!
by Ðerek wildstar
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...
by Ðerek wildstar
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://...
by Ðerek wildstar
15.08.2011, 14:16
Forum: ZeosLib 7.0 Beta Forum
Topic: Oracle 10.2 problem to connect
Replies: 8
Views: 2499

Hello! Can you explain better?
Mudrick wrote:I could not help this problem, because my database connection is always a problem.
by Ðerek wildstar
15.08.2011, 14:15
Forum: ZeosLib 7.0 Beta Forum
Topic: Oracle 10.2 problem to connect
Replies: 8
Views: 2499

Exatamente... Do jeito que você descreveu funciona. No meu caso eu preciso colocar ORADES.WORLD configurado em DATABASE e deixar host em branco. Mas isso não parece ser intuitivo. Por exemplo, intuitivamente, eu não usaria o TNS para conectar e usaria os "componentes" da string TNS para co...
by Ðerek wildstar
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...
by Ðerek wildstar
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...
by Ðerek wildstar
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...
by Ðerek wildstar
08.09.2009, 12:46
Forum: MySQL
Topic: Uniquely Indexed Column Problem
Replies: 5
Views: 482

mdaems wrote:Nope, I won't delete the topic. :P
So you'll never forget to look at custom components before reporting fake bugs :twisted:

Don't worry, the thread will sink away in the forum soon enough.

Mark
Hehehe OK I will pay more attention next time [:)]
by Ðerek wildstar
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 ...
by Ðerek wildstar
03.09.2009, 19:09
Forum: MySQL
Topic: Uniquely Indexed Column Problem
Replies: 5
Views: 482

Sorry for this post... I've found the error into one of my custom components...

SORRY SO MUCH!

PLEASE. DELETE THIS TOPIC! :oops:
by Ðerek wildstar
03.09.2009, 15:13
Forum: MySQL
Topic: Uniquely Indexed Column Problem
Replies: 5
Views: 482

Ok I'll do it Soon... Please wait! ;)

This is a very strang behaviour...
by Ðerek wildstar
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...