Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GuptaSteve
  • Order by date
  1. GuptaSteve

    OR in StrIFF

    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...
  2. GuptaSteve

    OR in StrIFF

    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...
  3. GuptaSteve

    SQLBase v12.1 has been released !

    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/
  4. GuptaSteve

    Sql Error No Sql cursors remaining - A SQL Handle Class you can use

    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/
  5. GuptaSteve

    Gupta SQL Handles class

    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/
  6. GuptaSteve

    The Gupta Team Developer WIKI, TD Sample Vault and the TD community forum have moved.

    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...
  7. GuptaSteve

    Transformation of SQL function into C# - How To Do It?

    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...
  8. GuptaSteve

    Hey: All

    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/
  9. GuptaSteve

    Cannot retrieve data from Oracle table

    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...
  10. GuptaSteve

    SQLtalk database name not configured

    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...
  11. GuptaSteve

    Request buckling up in V2.1

    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...
  12. GuptaSteve

    how to change column data type in a child table on runtime

    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...
  13. GuptaSteve

    Learn Centura online

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

    Learn Centura online

    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...
  15. GuptaSteve

    Need help with restoring database

    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...
  16. GuptaSteve

    need gupta class for sql server 2005 connection, guptasteve help me

    Your Mom ever teach you about please and thank you? I am a Gupta / Centura / SQLBase AP, available for permanent or long term contract work in UK, Australia, NZ or USA. See me at: http://www.linkedin.com/in/sleighton
  17. GuptaSteve

    VS.NET 'Add New Data Source' typed DataSet error

    What connectivity to SQLBase are you using ? Can you see any of the tables in SQLBase dB at any stage, and if so , maybe its an ownership problem i.e. Maybe you need to grant rights ( viz who created the tables ) The default for SQLBase is SYSADM.(tablename) - so you may need to specify this in...
  18. GuptaSteve

    need gupta class for sql server 2005 connection, guptasteve help me

    What SqlVarSetup problem do you mean? The class I refer to manages a Sql handle pool for Connecting/Disconnecting and Reusing - nothing to do with SqlVarSetup. Can you be more specific.
  19. GuptaSteve

    Join the 'SQLWindows Users & Developers Network'

    The 'LinkedIn' Network allows you to: Get introduced to the people you need, Find professionals that others can vouch for, Keep up with friends and work colleagues, Don’t miss professional opportunities, Build your own relationship network . More specifically, once a member of LinkedIn , you...
  20. GuptaSteve

    Problem getting data from a string field storing Binary data

    @CODE (string) or @HEX (number) any use ?

Part and Inventory Search

Back
Top