Search found 6 matches

by jwhitten
05.11.2013, 20:25
Forum: ZeosLib 7.1 stable Forum
Topic: Problem using TZTable, Lazarus, PostgreSQL and INET Datatype
Replies: 3
Views: 1387

Re: Problem using TZTable, Lazarus, PostgreSQL and INET Data

Your suggestion did end up working. I simply needed a little more experimentation in order to locate the best place to apply it. What I ended up doing was adding an 'OnChange' handler to the TDbEdit control like this: procedure TForm1.OnNullIfEmptyChange(Sender: TObject); begin with Sender as TDbEdi...
by jwhitten
05.11.2013, 18:25
Forum: ZeosLib 7.1 stable Forum
Topic: Problem using TZTable, Lazarus, PostgreSQL and INET Datatype
Replies: 3
Views: 1387

Re: Problem using TZTable, Lazarus, PostgreSQL and INET Data

>>What about TField.Clear? It isn't task of Zeos to null a value even if the IP-Field is a string-field with fixed Length. IMHO it's your task to null the field-value. Thanks for the opinion. That's kind of what I've been attempting to work out. I ran up the red flag awhile ago whilst still trying d...
by jwhitten
05.11.2013, 15:58
Forum: ZeosLib 7.1 stable Forum
Topic: Problem using TZTable, Lazarus, PostgreSQL and INET Datatype
Replies: 3
Views: 1387

Problem using TZTable, Lazarus, PostgreSQL and INET Datatype

Hello, I'm using Zeoslib 7.1.2-Stable with Lazarus 1.3 (from SVN) and I'm having a problem with using TZTable, PostgreSQL and the "INET" (PostgreSQL-specific) datatype. The "Inet" datatype is designed to work with IP Addresses, CIDR's and whatnot. I'm not really sure where to tac...
by jwhitten
01.11.2013, 17:06
Forum: ZeosLib 7.1 stable Forum
Topic: PostgreSQL Insert Problem - Prepared Statement - TZQuery
Replies: 2
Views: 1956

Re: PostgreSQL Insert Problem - Prepared Statement - TZQuery

Thanks for the reply. I figured out what the problem was last night. I was pulling my hair out trying to figure out why it wasn't working. I went through the source back and forth-- and then following it line by line as I was stepping through with the debugger. I saw where it has a field to provide ...
by jwhitten
30.10.2013, 14:26
Forum: ZeosLib 7.1 stable Forum
Topic: PostgreSQL Insert Problem - Prepared Statement - TZQuery
Replies: 2
Views: 1956

PostgreSQL Insert Problem - Prepared Statement - TZQuery

Hello, I recently upgraded Lazarus to 1.3 (from SVN) and Zeoslib to 7.1.2-stable, and I've started having problems with inserting new records. My tables all have SERIAL datatype primary keys and I have been using TZQueries for interacting with the database. My setup is very simple. I use a TZConnect...
by jwhitten
16.07.2013, 15:21
Forum: Documentations
Topic: Database component is not assigned
Replies: 4
Views: 5952

I know this is a response to an old thread but... In my experience, when you get the "Database connection is not assigned" error, it means that you left a dataset (TZTable, TZQuery, whatever) in the "Active" (Active := True) state before running the program. IMO, this should not ...