Recent content by GuptaSteve

p.s. Check out these links where you can post / view lots more info on any of the Gupta toolset incl. ReportBuilder Community Forum ( sign in and you get more options) Archived Community Forum Wiki Lots of Samples LinkedIn User Group Greetings from New Zealand ! GuptaSteve See Bankside...

Greetings from NZ ! And welcome to Gupta ReportBuilder. Hang in there it does get easier. Try: StrTranslate(inputvalue, 'AUD,NZD,GBP,EUR,HKD, ....','W, W, X, X, Y, ....') Syntax StrTranslate(inputvalue,csv1,csv2) Finds the value specified by inputvalue in csv1. The function takes the...

SQLBase v12.1 has been released ! Go here: SQLBase 12.1 to see more detail , or here: SQLBase Overview for an overview. GuptaSteve See us for all Gupta / Centura SQLWindows / SQLBase help at: https://www.banksidesystems.com/

thread854-992680 Go here : Gupta TeamDeveloper Samples , and search for the 'Handles' link , for a SQL Handle class. GuptaSteve See us for all Gupta / Centura SQLWindows / SQLBase help at: https://www.banksidesystems.com/

thread854-992680 Go here : Gupta TeamDeveloper Samples , and search for the 'Handles' link , for a SQL Handle class. GuptaSteve See us for all Gupta / Centura SQLWindows / SQLBase help at: https://www.banksidesystems.com/

Please update your website links to point to these new locations: [link forum.tdcommunity.net]Community Forum[/url] Archived Community Forum [link wiki.tdcommunity.net]Wiki[/url] [link samples.tdcommunity.net]TeamDeveloper / SQLBase Samples[/url] LinkedIn User Group GuptaSteve See us for all...

Your code looks like SQLServer TSQL. Its definatley not SQLBase or SQLWindows . I think you might be in the wrong forum. Alternatively , forget about C# , and I'll do it for you in Gupta SQLwindows ( TeamDeveloper ) , in about 1/2 the time, and 1/2 the number of lines. GuptaSteve See us for...

If you are referring to SQLWindows or SQLBase , go ahead - whats the question. GuptaSteve See us for all Gupta / Centura SQLWindows / SQLBase help at: https://www.banksidesystems.com/

Is the SQL handle connected ? If so try qualifying both the tablewindow and the sql handle. eg 'frm1.tbl1' and 'frm1.hSql'. If you return from SalTblPopulate , you can see if the Populate is actually executing ie 'If SalTblPopulate() Return TRUE , else Return FALSE' - put a break point...

Change servername=server1,sqlapipe,sqlws32 to servername=server1,sqlws32. Change DBNAME=VMFG,SQLAPIPE,SQLWS32 to DBNAME=VMFG,SQLWS32 Change [dbntsrv.dll]comdll=sqlapipe comdll=sqlws32 to [dbntsrv.dll];comdll=sqlapipe comdll=sqlws32 ps never run "ReOrganise' command. Alway use 'UNLOAD' then...

Are you talking about a table join ? Sorry - its not over clear what you mean. If you are querying the two tables in one query , give each table an alias , and join on the common column. eg Select a.blah,b.blah from table1 a , table2 b where a.blah = b.blah See me at...

Have you seen M!Table for exporting TableWindows to Excel - doesnt care what type of column you have. If not, I can direct you to it. or try SAL function: nColId = SalTblCreateColumnEx( hWndTbl, nColumnPos, nDispWidth, strTitle, nMaxChars, nDatatype ) Creates a table window column using a...

ps Your welcome . Dont mention it. See me at: http://www.linkedin.com/in/sleighton

Hmmmmm.. for a start please dont call it Centura any more - Centura changed names back to 'Gupta' about 10 years ago, then 'Unify' bought Gupta out, so now its 'Unify' . If you want a good overview of Unify TeamDeveloper go to...

Not sure of the answer to this - but if you post on the Unify SQLBase forum - you'll get much more exposure - and someone WILL know the answer. Log it on http://support.unify.com/supportforum/viewforum.php?f=35&sid=0733ddd0f853f8309ad72aac675de8f3 I am a Gupta / Centura / SQLBase AP, available...