Search found 53 matches

by duzenko
06.07.2009, 13:26
Forum: 6.6 - stable
Topic: Two problems inserting into firebird DB
Replies: 3
Views: 575

seawolf,

I use TZQuery "insert into Table1 (saletime) values (:saletime)" + Params[0].Value := MyTime.

MyTime is of type variant in that part of code
Field saletime is varchar
by duzenko
03.07.2009, 08:14
Forum: 6.6 - stable
Topic: Two problems inserting into firebird DB
Replies: 3
Views: 575

Two problems inserting into firebird DB

procedure TZAbstractRODataset.SetStatementParams, line 1015 case Param.DataType of ... ftCurrency: Statement.SetBigDecimal(I + 1, Param.AsCurrency); should be "ftCurrency, ftBCD" because currency fields remain NULL otherwise Did anyone test inserting time values (in delphi, it is double le...
by duzenko
02.07.2009, 15:03
Forum: 6.6 - stable
Topic: Incorrect error "Update Failed On Complex Query"
Replies: 11
Views: 1307

seawolf, do you suggest to update to svn version? I got a few other patches done by myself and I don't want to lose them
by duzenko
30.06.2009, 10:41
Forum: 6.6 - stable
Topic: Incorrect error "Update Failed On Complex Query"
Replies: 11
Views: 1307

mdaems,

I got a screenshot for you
by duzenko
22.06.2009, 12:43
Forum: 6.6 - stable
Topic: Incorrect error "Update Failed On Complex Query"
Replies: 11
Views: 1307

Inserting

Result := true; Exit;

into the beginning of TZInterbase6DatabaseMetadata.HasNoWildcards seems to help
by duzenko
22.06.2009, 12:09
Forum: 6.6 - stable
Topic: Incorrect error "Update Failed On Complex Query"
Replies: 11
Views: 1307

Incorrect error "Update Failed On Complex Query"

There are 2 tables in my DB: PLUSA and PLU__ In program, there is TZTable connected to PLU__. When I try to post updates to it, it gives "Cannot update a complex query with more then one table" Under debugger, I can see that in TZGenericCachedResolver.DefineTableName some columns have tabl...
by duzenko
17.06.2009, 12:01
Forum: 6.6 - stable
Topic: How to commit and refresh
Replies: 5
Views: 790

by duzenko
17.06.2009, 11:32
Forum: 6.6 - stable
Topic: How to commit and refresh
Replies: 5
Views: 790

How to commit and refresh

I have two applications and I need each one to be able to get data that another app has posted. And I can not get it. I have created a sample program that demonstrates my problem - run two instances of it When I change data in one instance, I can't see changes in another until program restart. Datas...