Could you explain how to insert an image on a table from SQL Assitant?
My_Table (ID Char(10,Image_File BLOB)
Thanks for your help!!
See "Importing Data" section in the SQL Assistant Help File. SQLA supports ?B and ?C parameter markers for BLOB and CLOB import data.
?B - The data for this parameter resides in a file that is in the same directory as the Import file. The import file contains only the name of the file to be imported. The contents of the file are loaded as a binary image.
?C - The data for this parameter resides in a file that is in the same directory as the import file. The import file contains only the name of the file to be imported. Use this marker to load a text file into a CHAR or CLOB column.