Error 1801, 3804

Discussion forum about all things SqlBase.
chad77

Re: Error 1801, 3804

Post by chad77 » 24 Mar 2016, 11:30

thanks :)

its ok

42> cur=225 snm=1 cfl=1 fcd=4 [execute]
42> SELECT USE_XML FROM PARAMCR
42> cur=225 snm=1 cfl=1 fcd=3 [compile]
42> cur=225 snm=1 cfl=1 fcd=4 [execute]
42> SELECT DEV_TAUX_CONV FROM DEVISE WHERE DEV_CODE='EU'
42> cur=225 snm=1 cfl=1 fcd=3 [compile]
42> cur=225 snm=1 cfl=1 fcd=4 [execute]
42> cur=225 snm=1 cfl=1 fcd=5 [fetch]
42> SELECT * FROM SYSTABLES WHERE NAME='CRETIQ'
42> cur=233 snm=1 cfl=1 fcd=3 [compile]
42> cur=233 snm=1 cfl=1 fcd=4 [execute]
42> SELECT * FROM SYSCOLUMNS WHERE TBNAME='DEPOT' AND NAME='PATH_LOGO'
42> cur=233 snm=1 cfl=1 fcd=3 [compile]
42> cur=233 snm=1 cfl=1 fcd=4 [execute]
42> SELECT VERSION_SOFT,SOFT_STOCK FROM LICENCE
42> cur=225 snm=1 cfl=1 fcd=3 [compile]
42> cur=225 snm=1 cfl=1 fcd=4 [execute]
42> SELECT GERE_MATIERE,GERE_COULEUR,GERE_THEME FROM PARAMARLEQ
42> cur=225 snm=1 cfl=1 fcd=3 [compile]
42> cur=225 snm=1 cfl=1 fcd=4 [execute]
42> SELECT * FROM COLORUSER WHERE COULEUR_USE=1 AND USR_NUM=:1
42> cur=233 snm=1 cfl=1 fcd=3 [compile]
42> cur=233 snm=1 cfl=1 fcd=4 [execute]
42> cur=233 snm=1 cfl=1 fcd=5 [fetch]
42> SELECT * FROM COULEUR WHERE COULEUR_USE=1
42> cur=233 snm=1 cfl=1 fcd=3 [compile]
42> cur=233 snm=1 cfl=1 fcd=4 [execute]

chad77

Re: Error 1801, 3804

Post by chad77 » 05 Apr 2016, 10:41

Hi ,

I daily errors 1801 - 3804 - 3806 with sqlbase12

why that happens ? I despair :( :( :( :(

help please

i'm french sorry

EwaldP
Austria
Posts: 343
Joined: 07 Mar 2017, 08:00
Location: Austria

Re: Error 1801, 3804

Post by EwaldP » 05 Apr 2016, 13:15

Are you sure that the listed Statements are the last before the error occurs?

What Isolation level do you use?
Ewald P. Palmetshofer
EDV-Hausleitner GmbH
4020 Linz
www.edv-hausleitner.at

chad77

Re: Error 1801, 3804

Post by chad77 » 05 Apr 2016, 13:33

i have this in my sql.ini


; The number of database pages that can be cached in memory
; Pages are per server, and shared with all databases
; Recommended: at least 20000
cache=128000
; The default value for readonly is 1, which allows use of "read only" and
; "read committed" (RO and RC) isolation levels. Uncommenting "readonly=0"
; will disallow use of RO and RC isolation levels.
;readonly=0

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests