Auto-checking data types and sizes in a DW to the DB.

[chris284]

Does anyone know if there is a program out there which will run through a given directory, go through each pibble, and pull all the data types/sizes from a datawindow, and compare the types/sizes to the corresponding table in the database? I'm wondering if there is some third party software out there, or if I will have to write this myself?

 

[thekl0wn]

I don't know of anything off the top of my head, but writing this shouldn't be too hard.

You should be able to write something of your own fairly simply. To loop through the dw's columns, use something like:

FOR ll_cnt = 1 TO Long( dw_example.Object.DataWindow.Column.Count )

Then, to get the column type, use something like:

ls_type = dw_example.Describe( '#' + String( ll_cnt ) + '.ColType' )

That should give you the types for the DataWindow. Now, the database structure may be a little different. You might look into the CreateFromSQL( ) function for DataWindows, and then use the same type of function as above.

 

[mbalent]

Remember that PB datatypes don't always correspond to the DB datatypes.

Matt

"Nature forges everything on the anvil of time