Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

I have to tranfer data from a child table to Excel, but this child table is created on runtime and all column are string. I need to transform some of these into number or date but I didn't find the function.. maybe it doesn't exists.. or maybe there is a library that I don't have...
The version of my Centura is 2.1 PTF 4 (I know, we are behind the times with the updating!!)
I hope someone could help me!

RE: 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 data type that you specify, at runtime.
When you return to design mode, SQLWindows destroys the column.


hWndTbl    Window Handle. The handle (or name) of a table window.
nColumnPos    Number. The Column Position
nDispWidth    Number. The display width of the column in inches.
strTitle    String. The column title.
nMaxChars    Number. The maximum number of characters that the column can contain.
nDatatype    Number. One of the constants DT_String, DT_Number, or DT_DateTime. Any other value will cause an error.
Return Value

nColId is the Column Identifier of the new column. nColld is negative one (-1) if an error occurs.


See me at: http://www.linkedin.com/in/sleighton

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close