Search:

what is this supposed to refresh? or should the refresh delegate be used for something to happen?
Regards

Thanks, it is fine now.
Regards

hi, in a before_update delegate i find that i am about to add a duplicate field, how can i revert/rollback ?

How about errors while working with an (ODBC) virtual table, is "on error" the way to...

Hi, ODBC test from console fails while "Datasource" test from "Administrative Tools" panel succeeds. This does'nt happen on Vista 32bits.
Driver is "MySQL ODBC 5.2 ANSI DRIVER" for Windows 64bits...

Both issues, seqno() and SQL count(), are sorted with RC8, great!
Best regards

Thanks a lot.

then no delegate is associated to the "commit/validate" action in a way similar to the "refresh" action?

This is an ordinary form section, I first validate with the "green tick", is this associated to a delegate? (I put "skip 0" in the refresh delegate (after validating) and update was written)
Regards

I noticed that an update in a form is written only when I change record (next, previous ...), is there a way to make sure it is written immediately ?
form is based on a virtual table mapped to a...

unless I am doing something wrong, seqno() does'nt behave that way
table structure
Structure for table : tab.dbf
Alias : tab
Number of records : 4
Date of creation ...

you mean in RC8?

I can't use seqno(), as it is re-initialised at app startup. It has to be a sequence used by surrogate keys. My workaround is a virtual table invoking a function defined on the db side.
Regards

can one use a select statement returning a single value for "default" ? what would be the syntax ? (enclosed, not enclosed ...)
ex : select max(id) from ids

Regards

done
Regards

Hi, delegate below is defined on a table with an autoincrement field "myid".
When creating a record, value in "myid" field is incremented but getElementById on this field returns the previous...

Should'nt a count on a table return 0 is no record is found? (as on all other databases)

open database southwind
select count(1) from employees where employeeid>0
No records selected
...

I could'nt reproduce on another machine with same software (centos 6.4 & builder RC7)...

can KEYMATCH() be used with a virtual table where primary indexes are a remote database?
Regards

in console

open database southwind
set debug on
select count(1) from employees where firstname='Anne......'

then Builder exists and debug_client.txt is empty

How, in a delegate, can I...

with "get data mapping" only set for field cities.provinceid
keylookup("provinces","xprovinceabrv",cities.provinceabrv,provinceid)
correct value for provinceid is return in form section from...

hi, i can lookup a field using the content of another field but it is not written in table

table provinces ( provinceid integer, provinceabrv char(4) )
with index xprovinceabrv on...

ok, it worker better, there is still something wrong when accessing photo through the virtual table.

I ried to create a catalog view section and no picture was displayed.

virtual table...

Hi, fail to retrieve employees.photograph through a virtualtable mapping a Lianja Sql Server table. This does'nt happen with ordinary colums.

virtual tables definition...

Its ok now, thanks

Hi, can connect with following data source
[LianjaDemo]
Driver = Lianja
DATABASE = ODBC:RECITAL:SERVERNAME=10.231.92.232;USERNAME=?;PASSWORD=?;DATABASE=southwind;

isql test
[root@lnxdev ~]#...

Well, it is working well with mysql ! All DML statements issued from a small app referencing 3 virtual tables mapping mysql tables went through successfully.
(Linux Builder RC7, MySQL 5.6.12,...