Search found 14 matches

by stiff
19.07.2009, 02:43
Forum: 6.6 - stable
Topic: How to empty ZTable
Replies: 3
Views: 813

How to empty ZTable

The way to empty the table is with the SQL DELETE from ddl.
by stiff
18.07.2009, 21:46
Forum: 6.6 - stable
Topic: Limit quantity of records in DataSet
Replies: 2
Views: 426

Limit quantity of records in DataSet

I have found how utilize the RecNo and RecordCount from ZTable. Sorry, it took me a little long than ave. to figure it out. :)
by stiff
18.07.2009, 21:39
Forum: 6.6 - stable
Topic: How to empty ZTable
Replies: 3
Views: 813

How to empty ZTable

I am not familiar with cached data and where it is. I am running the embedded version of fb and have created a temp table that will hold entered data because the operation pops in and out of other Forms. When finished and in Formdestroy, the table should be emptied for the next usage. How can the Em...
by stiff
18.07.2009, 15:27
Forum: 6.6 - stable
Topic: Limit quantity of records in DataSet
Replies: 2
Views: 426

Limit quantity of records in DataSet

Is it possible to limit the number of records that can be entered into a dataset or dbgrid either by pascal or SQL? ZTable doesn't have the RecNo or RecordCount properties. Can this be accomplished - if so, how? :)
by stiff
18.07.2009, 13:39
Forum: 6.6 - stable
Topic: How to empty ZTable
Replies: 3
Views: 813

How to empty ZTable

The ZTable doesn't have an EmptyTable method like the bde. How is this achieved? EmptyDataSet doesn't work.
by stiff
12.07.2009, 03:03
Forum: 6.6 - stable
Topic: Don't have privilegee
Replies: 1
Views: 307

The ZConnection has to be closed when loading the Fields Editor 8)
by stiff
12.07.2009, 00:06
Forum: 6.6 - stable
Topic: Don't have privilegee
Replies: 1
Views: 307

Don't have privilegee

Everything works fine within a test environment, but when a ZConnection and a ZSQL is plopped on a DataModule I get "This user does not have privilege to perform this operation on this object" I have set up the ZConnection just like when it was in a form. Thru the ZConnection it is connect...
by stiff
24.06.2009, 03:30
Forum: Firebird
Topic: D7 Firebird ZeosLib connection
Replies: 11
Views: 2728

I copied fbclientd.dll to Windows\System32 and moved the
fdb.Connected := true; to the end after fdb.Database := ......; and the .fdb file was created. hooray hooray. thanks a lot all.
by stiff
23.06.2009, 22:51
Forum: Firebird
Topic: D7 Firebird ZeosLib connection
Replies: 11
Views: 2728

All of those files are in directory that is being used, but I still get 'requested driver not found.'
by stiff
23.06.2009, 21:53
Forum: Firebird
Topic: D7 Firebird ZeosLib connection
Replies: 11
Views: 2728

:(
O.K. for tiReadCommitted;

but 'Open' crashed

I used fdb.Connected = true; instead and received 'requested database driver not found.' I am assuming that 'firebirdd-2.0' isn't found? Wouldn't that be in the embedded fbclientd.dll?
by stiff
23.06.2009, 19:49
Forum: Firebird
Topic: D7 Firebird ZeosLib connection
Replies: 11
Views: 2728

:(
The D7 compiler rejected some of the code:

undeclared identifier 'tiReadCommitted'
and also 'Open'

I used the directory path + the dbfilename in the [dbfullname]
by stiff
05.06.2009, 20:10
Forum: Firebird
Topic: D7 Firebird ZeosLib connection
Replies: 11
Views: 2728

Howdy:

Being that I am using the embedded version I don't think 'firebirdd-2.0' protocol should be used. Shouldn't it be firebird-2.0? What's the differece anyway? All I downloaded and need at the present is the embedded version.
by stiff
05.06.2009, 13:06
Forum: Firebird
Topic: D7 Firebird ZeosLib connection
Replies: 11
Views: 2728

D7 Firebird ZeosLib connection

I must really be dense. I can't find anything that shows how to make a .fdb file. I could with notepad or some text program, but it wouldn't seem right.
by stiff
05.06.2009, 04:26
Forum: Firebird
Topic: D7 Firebird ZeosLib connection
Replies: 11
Views: 2728

D7 Firebird ZeosLib connection

According to the docs the Database is a path to the working directory for the embedded project. In reality I haven't been able to make a ZConnection1.Connect. When it is tried, I get an AV: --------------------------- Debugger Exception Notification --------------------------- Project DBTest1.exe ra...