Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Function requires row or table buffering mode
Message
De
05/12/2005 14:41:47
 
 
À
05/12/2005 13:47:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01075021
Message ID:
01075053
Vues:
11
>I am getting the following error:
>Function requires row or table buffering mode
>on the last line for =table update (.t.,.t.)
>Could you please tell me, what's wrong with table or function. It used work fine.
>
>SELECT docudeck
>		APPEND BLANK
>		REPLACE docu_id with maxvalue
>		REPLACE file_name with ALLTRIM(finame)
>		REPLACE file_loc with ALLTRIM(mfile)
>		Replace no_pages with val(regpagesscan)
>		REPLACE scanby with ALLTRIM(guser)
>		REPLACE docindex_i with docindex.docindex_i
>		REPLACE proj_no	with alltrim(Upper(thisform.text1.value))
>		REPLACE workpkg_no with alltrim(Upper(thisform.text2.value))
>		REPLACE created_dt with date()
>	= TABLEUPDATE(.T.,.T.)
>
>
>Thank you very much for the information.

One line of code can replace all your lines, and it's quicker also:
Insert into docudeck (docu_id, file_name, file_loc, no_pages, scanby, docindex, proj_no, workpkg_no, created_dt);
  values (maxvalue, alltrim(finame), alltrim(mfile), val(regpagesscan), alltrim(guser), docindex.docindex_i,;
  alltrim(Upper(thisform.text2.value)), alltrim(Upper(thisform.text1.value)), date())
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform