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
Search found 53 matches
- 06.07.2009, 13:26
- Forum: 6.6 - stable
- Topic: Two problems inserting into firebird DB
- Replies: 3
- Views: 575
- 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...
- 02.07.2009, 15:03
- Forum: 6.6 - stable
- Topic: Incorrect error "Update Failed On Complex Query"
- Replies: 11
- Views: 1307
- 30.06.2009, 10:41
- Forum: 6.6 - stable
- Topic: Incorrect error "Update Failed On Complex Query"
- Replies: 11
- Views: 1307
- 22.06.2009, 12:43
- Forum: 6.6 - stable
- Topic: Incorrect error "Update Failed On Complex Query"
- Replies: 11
- Views: 1307
- 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...
- 17.06.2009, 12:01
- Forum: 6.6 - stable
- Topic: How to commit and refresh
- Replies: 5
- Views: 790
- 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...