Re: SQL Database + Array RDD
Posted: Sun Feb 07, 2010 5:42 pm
I tested Array RDD and find:
1. With next code
DEFINE WINDOW Win_1 ;
ROW 0 ;
COL 0 ;
WIDTH 500 ;
HEIGHT 400 ;
TITLE 'RDD SQL' ;
WINDOWTYPE MAIN
DEFINE GRID grid1
ROW 10
COL 10
WIDTH 470
HEIGHT 330
HEADERS {'Name','Family Name','Birth'}
WIDTHS {135,135,135}
ROWSOURCE "Persons"
COLUMNFIELDS {'Name','FamilyName','Birth'}
COLUMNCONTROLS { Name , FamilyName , Birth }
ALLOWEDIT .T.
END GRID
Program crash when I press ENTER twice. On first press can edit cell but on next press program crash
*************************************
Date:02/07/10 Time: 18:35:46
Error SQLMIX/0 Operation not supported
Called from RLOCK(0)
Called from SAVEDATAGRIDFIELD(2020)
Called from _HMG_GRIDINPLACEEDITOK(1158)
Called from (b)_HMG_GRIDINPLACEEDIT(733)
Called from _DOCONTROLEVENTPROCEDURE(4884)
Called from EVENTS(562)
Called from _DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(4548)
Called from _HMG_GRIDINPLACEEDIT(898)
Called from _HMG_GRIDINPLACEKBDEDIT_2(1707)
Called from EVENTS(1747)
Called from _DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(4526)
Called from DOMETHOD(7287)
Called from MAIN(49)
------------------------------------
2.
DEFINE WINDOW Win_1 ;
ROW 0 ;
COL 0 ;
WIDTH 500 ;
HEIGHT 400 ;
TITLE 'RDD SQL' ;
WINDOWTYPE MAIN
DEFINE BROWSE browse1
ROW 10
COL 10
WIDTH 470
HEIGHT 330
HEADERS {'Name','Family Name','Birth'}
WIDTHS {135,135,135}
WORKAREA Persons
FIELDS {'Name','FamilyName','Birth'}
ALLOWEDIT .T.
END BROWSE
Now program not crash and I can press ENTER many time and edit few cells
How to lock record for multiuser like BROWSE rlock for DBF table, is it possible?
1. With next code
DEFINE WINDOW Win_1 ;
ROW 0 ;
COL 0 ;
WIDTH 500 ;
HEIGHT 400 ;
TITLE 'RDD SQL' ;
WINDOWTYPE MAIN
DEFINE GRID grid1
ROW 10
COL 10
WIDTH 470
HEIGHT 330
HEADERS {'Name','Family Name','Birth'}
WIDTHS {135,135,135}
ROWSOURCE "Persons"
COLUMNFIELDS {'Name','FamilyName','Birth'}
COLUMNCONTROLS { Name , FamilyName , Birth }
ALLOWEDIT .T.
END GRID
Program crash when I press ENTER twice. On first press can edit cell but on next press program crash
*************************************
Date:02/07/10 Time: 18:35:46
Error SQLMIX/0 Operation not supported
Called from RLOCK(0)
Called from SAVEDATAGRIDFIELD(2020)
Called from _HMG_GRIDINPLACEEDITOK(1158)
Called from (b)_HMG_GRIDINPLACEEDIT(733)
Called from _DOCONTROLEVENTPROCEDURE(4884)
Called from EVENTS(562)
Called from _DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(4548)
Called from _HMG_GRIDINPLACEEDIT(898)
Called from _HMG_GRIDINPLACEKBDEDIT_2(1707)
Called from EVENTS(1747)
Called from _DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(4526)
Called from DOMETHOD(7287)
Called from MAIN(49)
------------------------------------
2.
DEFINE WINDOW Win_1 ;
ROW 0 ;
COL 0 ;
WIDTH 500 ;
HEIGHT 400 ;
TITLE 'RDD SQL' ;
WINDOWTYPE MAIN
DEFINE BROWSE browse1
ROW 10
COL 10
WIDTH 470
HEIGHT 330
HEADERS {'Name','Family Name','Birth'}
WIDTHS {135,135,135}
WORKAREA Persons
FIELDS {'Name','FamilyName','Birth'}
ALLOWEDIT .T.
END BROWSE
Now program not crash and I can press ENTER many time and edit few cells
How to lock record for multiuser like BROWSE rlock for DBF table, is it possible?