Back

Tip 34. Save Rows As SQL.

Within Powerbuilder or Infomaker you can use the menu option File->Save Rows As during a datawindow preview or by using the SaveAs() datawindow control function. This option will allow saving of many formats like CSV, tab separated, Excel and SQL.

The SQL is a very useful format for creating the SQL commands to create a table and the insert commands to add the contents based on the current datawindow.

I use this facility to give me SQL to populate a tables that update customer databases.

Added before 01 Jan 2000

Back