Suggested new Feature for RBASE:
? So here is good new feature: ? In the RBASE data design scree it would be nice to have Automatic SQL generation features right from the structure of the table, like ?- generate complete SELECT INTO statement for all fields ?- generate UPDATE statement for all files ?- generate INSERT statement for all fields. ? The RBASE could spawn the notepad with the generated SQL. - Boris -----Original Message----- From: Lawrence Lustig <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, Jun 26, 2009 10:38 am Subject: [RBASE-L] - Re: Limit to Long Varchar or Var for Varchar << UPDATE ptsoap SET subj = (subj + .vadjdesc2 + 'xxxxxxxxxxxxxxx 33333333333 ')? WHERE custnum = 4545 and ptspid = 4701 >> I'm guessing that the intermediate value you're calculating in the expression is being incorrectly typed as NOTE. Try SET VAR vSubj VARCHAR = NULL SELECT Subj INTO vSubj FROM PTSoap WHERE CustNum = 4545 AND PTSPID = 4701 SET VAR vSubj = (.vSubj + .vAdjDesc2 + 'Text Here') UPDATE PTSoad SET Subj = .vSubj WHERE CustNum = 4545 AND PTSPID = 4701 Make sure NOT to put parens around the variable name in the UPDATE statement. Does this help?? If not, is the error generated on line 3 or line 4 of the code? -- Larry
