Thanks Mr. Ramani for your solution.
May be my mistake, is in not using lock.
how about this way below ?
My reason is we adding new data when idTable is in Lock.
where is the best way like the first.
IF RLOCK('idTable')
myNextId = idTable.IdNo
REPLACE idTable.IdNo WITH myNextId+1...
Thnks Mr. Ramani, this is my clearly of my question.
I have 2 tables named TrxAir and TrxSea.
In the Transaction I have 2 Forms like :
Form "Air Transaction" using Table TrxAir and "Sea Transaction" using TrxSea.
this is my listing.
*** Info...
Hi all,
1. what is the default of empty datetime format ?
2. eg.
I have 2 tables
TableA( id c(6)) and TableB( id c(6)).
Unique id format is like 'A99999'
How to make an unique id from combining of that two tables, so there is not an duplicate id from both tables ?
Thanks
Hi All,
I have confuse with textbox focus.
I already set format with K, and the meaning when cursor go to the textbox, it's will be block and when i type anything, it will be replaced with the new entry. But when the textbox clicking by mouse the K format is ignored. and the meaning when i type...
Hi All,
i have 2 table with same fieldname
tableA (code c(7)) and tableB (code c(7))
tableA has 500,000 records from 'A000000' to 'A500000'
and tableB has 400,000 records from 'A500001' to 'A900001'
How to fast combining both table in a corsor and knowing max code record ?
Thanks for help.
here's the code :
Local cConsole
cConsole = SET("CONSOLE")
SET CONSOLE OFF
SELECT DtlMawb
WITH Thisform.pfm.pgd
CALCULATE SUM(DtlMawb.ngrossout) ;
FOR HdrMawb.cnomawb = .txtcnomawb.Value AND NOT DELETED();
TO .txtnaGrossout.Value...
Hi all,
I have a total value as 88.6840 but it's save as 88.6800.
I already to set decimal to 4.
any advice, please ?, cause i absolutely forget to handle this problem.
Thanks
I have a table with fields like :
TableA
Field1 C 10
Field2 N 7,2
Field3 D 8
How do i identify all field types and widths and decimals with a programaticly.
thanks for all advices.
i have a shared folder named Folder1.
and have create 3 users (A, B, and C).
eg.
Folder1 (sharing name is public1) = public folder
|_ Folder2 (allowed to user A only)
|_ Folder3 (allowed to user B only)
|_ Folder4 (allowed to user C only)
How to setting like that.
Sorry, i just a...
i have parameter named pUser.
pUser = 'UserA,UserB,UserC,UserD'
can i break it to array to be :
array(1)='UserA'
array(2)='UserB'
array(3)='UserC'
array(4)='UserD'
can you help me, please ...
Thanks for your advice Mr.craigsboyd,
But it will show all field in grid.
here i mean :
with that classform, i create 2 forms :
FromName :FormA
Table :TableA (Kode,Name,Address,phone,email)
Field use: Kode,Name,phone,email
FromName :FormB
Table :TableB (Kode,Name,Address,phone,email)...
In commandbutton.click(),Stored :
cxKode=Space(6)
do form formtwo
* Command must stop here and do bellow after formtwo closed
* or running until "endif" then stop ?
If not empty(cxkode)
......
Endif
* If it stop after "do form", why my button is stop after "endif"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.