FiveTech Software tech support forums

In a Sql concept,you will do : oRs:Open("select ID FROM TABLE1",oCon) wid:=oRs:Fields("ID"):Value wid:=wid+1 UPDATE TABLE1 SET ID=wid * How can you lock, how are you sure that this code is not execute at the same time from another computer using the same application . ======= In ...

I am back with this problem .

Could someone share some sample of code of transaction with fivewin .

Thanks

Marc,
Is it possible to give a sample of code .

I read in the past that it is possible to use a SQL table in exclusive mode , how to ?

Thanks.

I agree with you BUTthe custumer ask me to reset the counter to 1 each month.

There is a prefix in front of the invoice number who is YYYYMM-invoice number ==> 201506-0001 .....

Thanks for your help .

Hello, I have an invoice file with a field InvoiceNumber, when the user add a record, the invoice number must be the last one + 1 In a SQL network environment, how can i be shure that dont have 2 times the same number . With DBF, when i want to do the same, i open an other file (LOCK.DBF) in EXCLUSI...

Thanks
This code works good !

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

Hi,
What is the equivalent of DISPLAY STRUCTURE for an access or MS SQL database ?

Thanks .

Thanks for your help .

It works .

Thanks

When i execute an application with Remote Desktop (TS) ,
the function GetEnv( "COMPUTERNAME" ) return the NAME of the SERVER and not the name of the workstation that execute Remote Desktop .

How to know this name ?

Thanks

Try STRTRAN(var," ","")

Good luck

Hello,
We have sample to send mail with Gmail .

I am looking for a sample to send mail with OWA (Outlook Web Access)

Thanks for your help .

Here is my code :

vdata:={}
for a=1 to fcount()
aadd(vdata,fieldget(a))
next
append blank


if rlock()
for e=1 to fcount()
fieldput(e,vdata[e])
next
unlock
skip 0
else
MsgAlert("Lock error !!")
endif

Thanks for this info .

Hi, I have a DBF file with 5 fields , it is an audit files . The size is actualy 1 284 545 259 and the number of records is 5 400 000 . This file is used to audit the modification and in only open durring 1 seconds each time a record is added . Is there a limit for number of records and the size of ...

What about this meeting ?

Is it for 2014 or 2015 ?

Do you have a location ?

Thanks !