@ 2.615,1.667 GET FromPop PICTURE "@&N" POPUP BQFromPop SIZE 6.923,20.800 DEFAULT " " FONT "MS Sans Serif", 8 STYLE ""
@ 2.615,21.167 GET SelectPop PICTURE "@&N" POPUP BQSelectPo SIZE 6.923,35.200 DEFAULT " " FONT "MS Sans Serif", 8 STYLE "" VALID _qg30iwstg()
MS Sans Serif
@*VN \<Select...
MS Sans Serif
@*VN \<Join...
MS Sans Serif
@*VN \<Where...
@ 12.615,1.833 GET EditWhere PICTURE "@&N" FROM WhereList RANGE 1, ALEN(WhereList) - 1 SIZE 8.077,83.800 DEFAULT 1 FONT "MS Sans Serif", 8 VALID _qg30iwtbd()
buildquery
SET READBORDER &rborder
TALKz
COMPATIBLEz
buildquery
BUILDQUERY
BUILDQUERY.PJX
BUILDQUERY
BUILDQUERY.SCX
BUILDQUERY
BUILDQUERY.MNX
BUILDQUERY
BUILDQUERY.PRG
BUILDQUERY
BUILDQUERY.FRX
BUILDQUERY
BUILDQUERY.QPR
Build Query
No tables in database
buildquery
@*VT \! E\<xecute ;\<Edit...;C\<lear;\?Close
@*VN \<From...
@ 1,1 GET FromPop PICTURE "@&N" POPUP BQFromPop SIZE 8,24 DEFAULT " " COLOR SCHEME 2
@ 1,26 GET SelectPop PICTURE "@&N" POPUP BQSelectPo SIZE 8,31 DEFAULT " " VALID _qg30iwv7u() COLOR SCHEME 2
@*VN \<Select...
@*VN \<Join...
@*VN \<Where...
@ 11,1 GET EditWhere PICTURE "@&N" FROM WhereList RANGE 1, ALEN(WhereList) - 1 SIZE 7,74 DEFAULT 1 VALID _qg30iwvou() COLOR SCHEME 2
Microsoft FoxPro Connectivity Kit Sample Application
MS Sans Serif
Copyright
1993 Microsoft Corp.
MS Sans Serif
Version: 2.5
MS Sans Serif
MS Sans Serif
@*HT Close
Connected to
MS Sans Serif
MS Sans Serif
333333Q@
aboutck
SET READBORDER &rborder
TALKz
COMPATIBLEz
aboutck
ABOUTCK
ABOUTCK.PJX
ABOUTCK
ABOUTCK.SCX
ABOUTCK
ABOUTCK.MNX
ABOUTCK
ABOUTCK.PRG
ABOUTCK
ABOUTCK.FRX
ABOUTCK
ABOUTCK.QPR
About CKSample
aboutck
Microsoft FoxPro Connectivity Kit Sample Application
Version: BETA2
@*HT OK
Connected to
Copyright (c) 1993 Microsoft Corp.
aboutck
CURRAREA
TALKSTAT
COMPSTAT
RBORDER
ABOUTCK
GETOUT
MESS_STR
TALKz
COMPATIBLEz
READBORDERz
_qfx0th3vh
MS Sans Serif
How to use CKSample
helpdata
_qfx0th3vh
FoxFont
MS Sans Serif
@*HT Close
_qfx0th3vh
SET READBORDER &rborder
TALKz
COMPATIBLEz
_qfx0th4k0
How to use CKSample
helpdata
_qfx0th4k0
@*HT OK
_qfx0th4k0
CURRAREA
TALKSTAT
COMPSTAT
RBORDER
_QFX0TH3VHHELPDATA
HHELPTEXT
_QFX0TH4K0
HELPTEXT
958
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
To be written
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
This is the hekp text
The CKSAMPLE application lets you quickly and easily perform some of the basic operations associated with a client front end, such as connecting to a data source, using a database on the data source, and querying data. CKSAMPLE also lets you set various options, edit SQL commands to be sent to the data
source, and convert a data source memo field with binary data to a FoxPro general type field.
+===================================+
| CONNECTING TO A DATA SOURCE |
+===================================+
NOTE: Before you can connect to a data source, the appropriate driver for the data source must have
previously been installed on your machine.
When you run CKSAMPLE.APP, the Connect to Data Source dialog opens. This dialog contains the
following objects:
Data Source text box -- type the name of the data source to which you want to connect. This
information is required in order to connect to a data source.
User Identifier text box -- type the user identification under which you want to log on to the data
source. This information is required in order to connect to a data source.
Password text box -- If the data source has password protection, type the password in this text
box. If the data source doesn't require a password, this text box can be left empty.
Connect String text box -- If the data source accepts instructions or commands when a connection
is made, you can include that instruction in the Connect String text box. If the data source does not accept
instructions or commands at the time of connection, anything typed in the Connect String text box is
ignored. This text box can be left empty.
OK and Cancel buttons -- Choose OK to attempt the connection specified in the various text
boxes in this dialog. If the connection is successful, a successful connection message is displayed in a wait
window and the name of the data source is displayed on the status bar. If you cannot connect, an error
message is displayed and you are returned to the dialog.
When you run CKSAMPLE.APP, you must connect to a data source. If you choose Cancel,
CKSAMPLE.APP terminates.
To change data source connections, choose Disconnect from the Database menu, then choose
Connect... from the Database menu. The Connect to Data Source dialog opens. Again, you need to
indicate a data source to connect to and a user identification, as well as a password and connect string if
desired, then choose OK. If you choose Cancel, no attempt is made to connect to a data source and the
dialog is closed, but CKSAMPLE.APP continues to run.
+===================================+
| USING A DATABASE |
+===================================+
Multiple databases can be stored on a single data source and a database can contain a number of tables.
When you are connected to a data source, you can use a database on that source. To use the database
whose data you want to access, choose Use Database... from the Database menu. The Use Database dialog
opens. Type the name of the database you want to use in the text box and choose OK. To use a different
database, follow the same steps. You can use only one database at a time. Once you use a database, the
name of the database is displayed on the status bar and all the tables in that database are available for
querying.
+===================================+
| CREATING A QUERY |
+===================================+
You can allow CKSAMPLE.APP to build a SQL statement based on your choices in the Build Query
dialog or write your own SQL statement in the Edit Query dialog.
Choose Build Query... from the Query menu to open the Build Query dialog. This dialog contains the
following objects:
From... button -- Choose tables to be included in the query.
Choosing the From... button opens the From dialog with a list of the tables in the database currently in use
and a list of tables from this database to be included in the query. To move a table from the Database tables
list into the Query tables list, double-click it or select it with the mouse or keyboard and choose Add>>.
To remove a table from the Query tables list, double-click it or select it with the mouse or keyboard and
choose <<Remove. When the desired tables are in the Query tables list, choose OK. The chosen tables are
displayed in the Build Query dialog.
Select... button -- Choose columns (fields) from the tables to be included in the query.
Choose the Select... button to open the Select dialog with a list of the columns in the tables selected in the
From dialog and a list of columns from these tables to be included in the query. To move a table from the
Database tables list into the Query tables list, double-click it or select it with the mouse or keyboard and
choose Add>>. To remove a table from the Query tables list, double-click it or select it with the mouse or
keyboard and choose <<Remove. When the desired tables are in the Query tables list, choose OK. The
chosen tables are displayed in the Build Query dialog.
Join... button -- Specify join conditions for the tables in the query.
Choose the Join... button to open the Join dialog. Select the columns to be joined from the popups on the
left and right sides of the dialog and the condition of the join from the center popup. A condition can be
reversed by checking the NOT check box. Choose OK to complete the join or Cancel to leave the dialog
without setting a join condition. If you include more than one table in a query, you should specify a join
condition for every table. To specify additional join conditions, repeat the above steps.
Where... button -- Specify filter conditions for the query.
Choose the Where... button to open the Where dialog. Select the column to be filtered from the popup on
the left side of the dialog and the condition of the filter from the center popup. Type the comparison
number or string in the text box on the right side of the dialog.. A condition can be reversed by checking
the NOT check box. Choose OK to set the filter or Cancel to leave the dialog without setting a filter
condition.
Execute button -- Execute the query.
Edit... button -- Edit the SQL statement built in the Build Query dialog.
Choose the Edit... button to open the Edit dialog. The SQL statement built in the Build Query dialog is
displayed in a text editing window so that you can customize the query. Choose the Execute button in the
Edit dialog to execute the SQL statement. If you choose Cancel, the Edit dialog closes and the query is not
executed.
Clear button -- Remove all tables, columns, join conditions, and filter conditions from the query
being built.
Close button -- Close the Build Query dialog.
You can directly edit a SQL statement by choosing Edit Query... from the Query menu. This opens the
Edit dialog described above.
To execute a query already built, choose Execute Query from the Query menu
+===================================+
| SETTING OPTIONS |
+===================================+
To set various options that affect the connection to the data source and the way in which result sets are
processed, choose Options... from the Database menu. The Options dialog opens with the following
objects:
Result Set -- Determine whether results are returned in cursors or tables.
Execution Mode -- Determine whether operations over the data source connection are processed
synchronously, so that the entire procedure is performed before control is returned to CKSAMPLE.APP, or
asynchronously, so that control is periodically returned to CKSAMPLE.APP.
Timeout (in seconds) -- Determine the length of time in seconds FoxPro will wait before timing out for a
connection to be made or for a connection already made to respond.
Memo cutoff -- Determine the minimum length of a column for it to stored in a FoxPro table or cursor as a
memo field. Columns shorter than the cutoff are stored as normal fields in a FoxPro table or cursor.
Display View window -- Displays the View window. The View window must be open to Convert a memo,
which is described in the following section.
+===================================+
| COVERTING A MEMO |
+===================================+
Data source memo columns can often contain binary information as well as text. Binary data is stored in
general fields in FoxPro tables. To convert binary information from a data source query which has been
stored to a memo field in a FoxPro table into a general type:
1. Make sure the View Window is open. You can open the View window by choosing Options...
from the Database menu and choosing the Display View Window check box in the Options dialog.
2. Make sure that result sets are returned in tables. If result sets are returned in cursors, you
cannot convert memo fields to general fields.
3. Execute a SQL query that creates a table or cursor with a memo field. For information about
executing a query, see the section titled CREATING A QUERY above.
4. Choose Convert Memo... from the Database menu.
5. Select the memo to convert in the Convert Memo dialog and choose OK.
The CKSAMPLE application lets you quickly and easily perform some of the basic operations associated with a client front end, such as connecting to a data source, using a database on the data source, and querying data. CKSAMPLE also lets you set various options, edit SQL commands to be sent to the data
source, and convert a data source memo field with binary data to a FoxPro general type field.
Connecting to a Data Source
NOTE: Before you can connect to a data source, the appropriate driver for the data source must have previously been installed on your machine.
When you run CKSAMPLE.APP, the Connect to Data Source dialog opens. This dialog contains the following objects:
Data Source text box -- type the name of the data source to which you want to connect. This information is required in order to connect to a data source.
User Identifier text box -- type the user identification under which you want to log on to the data source. This information is required in order to connect to a data source.
Password text box -- If the data source has password protection, type the password in this text box. If the data source doesn't require a password, this text box can be left empty.
Connect String text box -- If the data source accepts instructions or commands when a connection is made, you can include that instruction in the Connect String text box. If the data source does not accept instructions or commands at the time of connection, anything typed in the Connect String text box is ignored. This text box can be left empty.
OK and Cancel buttons -- Choose OK to attempt the connection specified in the various text boxes in this dialog. If the connection is successful, a successful connection message is displayed in a wait window and the name of the data source is displayed on the status bar. If you cannot connect, an error message is displayed and you are returned to the dialog.
When you run CKSAMPLE.APP, you must connect to a data source. If you choose Cancel, CKSAMPLE.APP terminates.
To change data source connections, choose Disconnect from the Database menu, then choose Connect... from the Database menu. The Connect to Data Source dialog opens. Again, you need to indicate a data source to connect to and a user identification, as well as a password and connect string if
desired, then choose OK. If you choose Cancel, no attempt is made to connect to a data source and the dialog is closed, but CKSAMPLE.APP continues to run.
Using a Database
Multiple databases can be stored on a single data source and a database can contain a number of tables. When you are connected to a data source, you can use a database on that source. To use the database whose data you want to access, choose Use Database... from the Database menu. The Use Database dialog
opens. Type the name of the database you want to use in the text box and choose OK. To use a different database, follow the same steps. You can use only one database at a time. Once you use a database, the name of the database is displayed on the status bar and all the tables in that database are available for querying.
Creating a Query
You can allow CKSAMPLE.APP to build a SQL statement based on your choices in the Build Query dialog or write your own SQL statement in the Edit Query dialog.
Choose Build Query... from the Query menu to open the Build Query dialog. This dialog contains the following objects:
From... button -- Choose tables to be included in the query.
Choosing the From... button opens the From dialog with a list of the tables in the database currently in use and a list of tables from this database to be included in the query. To move a table from the Database tables
list into the Query tables list, double-click it or select it with the mouse or keyboard and choose Add>>. To remove a table from the Query tables list, double-click it or select it with the mouse or keyboard and choose <<Remove. When the desired tables are in the Query tables list, choose OK. The chosen tables are displayed in the Build Query dialog.
Select... button -- Choose columns (fields) from the tables to be included in the query.
Choose the Select... button to open the Select dialog with a list of the columns in the tables selected in the From dialog and a list of columns from these tables to be included in the query. To move a table from the Database tables list into the Query tables list, double-click it or select it with the mouse or keyboard and choose Add>>. To remove a table from the Query tables list, double-click it or select it with the mouse or keyboard and choose <<Remove. When the desired tables are in the Query tables list, choose OK. The
chosen tables are displayed in the Build Query dialog.
Join... button -- Specify join conditions for the tables in the query.
Choose the Join... button to open the Join dialog. Select the columns to be joined from the popups on the left and right sides of the dialog and the condition of the join from the center popup. A condition can be
reversed by checking the NOT check box. Choose OK to complete the join or Cancel to leave the dialog without setting a join condition. If you include more than one table in a query, you should specify a join condition for every table. To specify additional join conditions, repeat the above steps.
Where... button -- Specify filter conditions for the query.
Choose the Where... button to open the Where dialog. Select the column to be filtered from the popup on the left side of the dialog and the condition of the filter from the center popup. Type the comparison number or string in the text box on the right side of the dialog.. A condition can be reversed by checking
the NOT check box. Choose OK to set the filter or Cancel to leave the dialog without setting a filter condition.
Execute button -- Execute the query.
Edit... button -- Edit the SQL statement built in the Build Query dialog.
Choose the Edit... button to open the Edit dialog. The SQL statement built in the Build Query dialog is displayed in a text editing window so that you can customize the query. Choose the Execute button in the Edit dialog to execute the SQL statement. If you choose Cancel, the Edit dialog closes and the query is not executed.
Clear button -- Remove all tables, columns, join conditions, and filter conditions from the query being built.
Close button -- Close the Build Query dialog.
You can directly edit a SQL statement by choosing Edit Query... from the Query menu. This opens the Edit dialog described above.
To execute a query already built, choose Execute Query from the Query menu
Setting Options
To set various options that affect the connection to the data source and the way in which result sets are processed, choose Options... from the Database menu. The Options dialog opens with the following
objects:
Result Set -- Determine whether results are returned in cursors or tables.
Execution Mode -- Determine whether operations over the data source connection are processed synchronously, so that the entire procedure is performed before control is returned to CKSAMPLE.APP, or asynchronously, so that control is periodically returned to CKSAMPLE.APP.
Timeout (in seconds) -- Determine the length of time in seconds FoxPro will wait before timing out for a connection to be made or for a connection already made to respond.
Memo cutoff -- Determine the minimum length of a data source column for it to stored in a FoxPro table or cursor as a memo field. Columns shorter than the cutoff are stored as normal fields in a FoxPro table or cursor.
Display View window -- Displays the View window. The View window must be open to Convert a memo, which is described in the following section.
Converting a Memo
Data source memo columns can often contain binary information as well as text. Binary data is stored in general fields in FoxPro tables. To convert binary information from a data source query which has been stored to a memo field in a FoxPro table into a general type:
1. Make sure the View Window is open. You can open the View window by choosing Options... from the Database menu and choosing the Display View Window check box in the Options dialog.
2. Make sure that result sets are returned in tables. If result sets are returned in cursors, you cannot convert memo fields to general fields.
3. Execute a SQL query that creates a table or cursor with a memo field. For information about executing a query, see the section titled CREATING A QUERY above.
4. Choose Convert Memo... from the Database menu.
5. Select the memo to convert in the Convert Memo dialog and choose OK.
Exiting CKSAMPLE.APP
To Exit CKSAMPLE.APP, choose Exit from the Database menu. A dialog with the following objects opens to confirm that you want to exit:
Yes button -- Choose to exit.
No button -- Return to CKSAMPLE.APP.
Close Tables on Exit check box --
The CKSAMPLE application lets you quickly and easily perform some of the basic operations associated with a client front end, such as connecting to a data source, using a database on the data source, and querying data. CKSAMPLE also lets you set various options, edit SQL commands to be sent to the data
source, and convert a data source memo field with binary data to a FoxPro general type field.
Connecting to a Data Source
NOTE: Before you can connect to a data source, the appropriate driver for the data source must have previously been installed on your machine.
When you run CKSAMPLE.APP, the Connect to Data Source dialog opens. This dialog contains the following objects:
Data Source text box -- type the name of the data source to which you want to connect. This information is required in order to connect to a data source.
User Identifier text box -- type the user identification under which you want to log on to the data source. This information is required in order to connect to a data source.
Password text box -- If the data source has password protection, type the password in this text box. If the data source doesn't require a password, this text box can be left empty.
Connect String text box -- If the data source accepts instructions or commands when a connection is made, you can include that instruction in the Connect String text box. If the data source does not accept instructions or commands at the time of connection, anything typed in the Connect String text box is ignored. This text box can be left empty.
OK and Cancel buttons -- Choose OK to attempt the connection specified in the various text boxes in this dialog. If the connection is successful, a successful connection message is displayed in a wait window and the name of the data source is displayed on the status bar. If you cannot connect, an error message is displayed and you are returned to the dialog.
When you run CKSAMPLE.APP, you must connect to a data source. If you choose Cancel, CKSAMPLE.APP terminates.
To change data source connections, choose Disconnect from the Database menu, then choose Connect... from the Database menu. The Connect to Data Source dialog opens. Again, you need to indicate a data source to connect to and a user identification, as well as a password and connect string if
desired, then choose OK. If you choose Cancel, no attempt is made to connect to a data source and the dialog is closed, but CKSAMPLE.APP continues to run.
Using a Database
Multiple databases can be stored on a single data source and a database can contain a number of tables. When you are connected to a data source, you can use a database on that source. To use the database whose data you want to access, choose Use Database... from the Database menu. The Use Database dialog
opens. Type the name of the database you want to use in the text box and choose OK. To use a different database, follow the same steps. You can use only one database at a time. Once you use a database, the name of the database is displayed on the status bar and all the tables in that database are available for querying.
Creating a Query
You can allow CKSAMPLE.APP to build a SQL statement based on your choices in the Build Query dialog or write your own SQL statement in the Edit Query dialog.
Choose Build Query... from the Query menu to open the Build Query dialog. This dialog contains the following objects:
From... button -- Choose tables to be included in the query.
Choosing the From... button opens the From dialog with a list of the tables in the database currently in use and a list of tables from this database to be included in the query. To move a table from the Database tables
list into the Query tables list, double-click it or select it with the mouse or keyboard and choose Add>>. To remove a table from the Query tables list, double-click it or select it with the mouse or keyboard and choose <<Remove. When the desired tables are in the Query tables list, choose OK. The chosen tables are displayed in the Build Query dialog.
Select... button -- Choose columns (fields) from the tables to be included in the query.
Choose the Select... button to open the Select dialog with a list of the columns in the tables selected in the From dialog and a list of columns from these tables to be included in the query. To move a table from the Database tables list into the Query tables list, double-click it or select it with the mouse or keyboard and choose Add>>. To remove a table from the Query tables list, double-click it or select it with the mouse or keyboard and choose <<Remove. When the desired tables are in the Query tables list, choose OK. The
chosen tables are displayed in the Build Query dialog.
Join... button -- Specify join conditions for the tables in the query.
Choose the Join... button to open the Join dialog. Select the columns to be joined from the popups on the left and right sides of the dialog and the condition of the join from the center popup. A condition can be
reversed by checking the NOT check box. Choose OK to complete the join or Cancel to leave the dialog without setting a join condition. If you include more than one table in a query, you should specify a join condition for every table. To specify additional join conditions, repeat the above steps.
Where... button -- Specify filter conditions for the query.
Choose the Where... button to open the Where dialog. Select the column to be filtered from the popup on the left side of the dialog and the condition of the filter from the center popup. Type the comparison number or string in the text box on the right side of the dialog.. A condition can be reversed by checking
the NOT check box. Choose OK to set the filter or Cancel to leave the dialog without setting a filter condition.
Execute button -- Execute the query.
Edit... button -- Edit the SQL statement built in the Build Query dialog.
Choose the Edit... button to open the Edit dialog. The SQL statement built in the Build Query dialog is displayed in a text editing window so that you can customize the query. Choose the Execute button in the Edit dialog to execute the SQL statement. If you choose Cancel, the Edit dialog closes and the query is not executed.
Clear button -- Remove all tables, columns, join conditions, and filter conditions from the query being built.
Close button -- Close the Build Query dialog.
You can directly edit a SQL statement by choosing Edit Query... from the Query menu. This opens the Edit dialog described above.
To execute a query already built, choose Execute Query from the Query menu
Setting Options
To set various options that affect the connection to the data source and the way in which result sets are processed, choose Options... from the Database menu. The Options dialog opens with the following
objects:
Result Set -- Determine whether results are returned in cursors or tables.
Execution Mode -- Determine whether operations over the data source connection are processed synchronously, so that the entire procedure is performed before control is returned to CKSAMPLE.APP, or asynchronously, so that control is periodically returned to CKSAMPLE.APP.
Timeout (in seconds) -- Determine the length of time in seconds FoxPro will wait before timing out for a connection to be made or for a connection already made to respond.
Memo cutoff -- Determine the minimum length of a data source column for it to stored in a FoxPro table or cursor as a memo field. Columns shorter than the cutoff are stored as normal fields in a FoxPro table or cursor.
Display View window -- Displays the View window. The View window must be open to Convert a memo, which is described in the following section.
Converting a Memo
Data source memo columns can often contain binary information as well as text. Binary data is stored in general fields in FoxPro tables. To convert binary information from a data source query which has been stored to a memo field in a FoxPro table into a general type:
1. Make sure the View Window is open. You can open the View window by choosing Options... from the Database menu and choosing the Display View Window check box in the Options dialog.
2. Make sure that result sets are returned in tables. If result sets are returned in cursors, you cannot convert memo fields to general fields.
3. Execute a SQL query that creates a table or cursor with a memo field. For information about executing a query, see the section titled CREATING A QUERY above.
4. Choose Convert Memo... from the Database menu.
5. Select the memo to convert in the Convert Memo dialog and choose OK.
Exiting CKSAMPLE.APP
To Exit CKSAMPLE.APP, choose Exit from the Database menu. A dialog with the following objects opens to confirm that you want to exit:
Yes button -- Choose to exit.
No button -- Return to CKSAMPLE.APP.
Close Tables on Exit check box -- Determine the state of tables after exit.
If Close Tables on Exit is checked, tables and cursors created by queries in CKSAMPLE.APP are closed when you leave CKSAMPLE.APP. If the result sets were stored to tables, you can open them again after you exit CKSAMPLE.APP. If the result sets were stored to cursors, they no longer exist when you exit CKSAMPLE.APP. To make result sets stored to cursors available after you exit CKSAMPLE.APP, uncheck the Close Tables on Exit check box.
The CKSAMPLE application lets you quickly and easily perform some of the basic operations associated with a client front end, such as connecting to a data source, using a database on the data source, and querying data. CKSAMPLE also lets you set various options, edit SQL commands to be sent to the data source, and convert a data source memo field with binary data to a FoxPro general type field.
Connecting to a Data Source
NOTE: Before you can connect to a data source, the appropriate driver for the data source must be installed on your machine.
When you run CKSAMPLE.APP, the Connect to Data Source dialog opens. This dialog contains the following objects:
Data Source text box -- Type the name of the data source to which you want to connect. This information is required in order to connect to a data source.
User Identifier text box -- Type the user identification under which you want to log on to the data source. This information is required in order to connect to a data source.
Password text box -- If the data source has password protection, type the password in this text box. If the data source doesn't require a password, you can leave this text box empty.
Connect String text box -- If the data source accepts instructions or commands when a connection is made, you can include that instruction in the Connect String text box. If the data source does not accept instructions or commands at the time of connection, anything typed in the Connect String text box is ignored. This text box can be left empty.
OK and Cancel buttons -- Choose OK to attempt the connection specified in the various text boxes in this dialog. If the connection is successful, a successful connection message is displayed in a wait window and the name of the data source is displayed on the status bar. If you cannot connect, an error message is displayed and you are returned to the dialog.
When you run CKSAMPLE.APP, you must connect to a data source. If you choose Cancel, CKSAMPLE.APP terminates.
To change data source connections, choose Disconnect from the Database menu, then choose Connect... from the Database menu. The Connect to Data Source dialog opens. Again, you need to indicate a data source to connect to and a user identification, as well as a password and connect string if desired, then choose OK. If you choose Cancel, no attempt is made to connect to a data source and the dialog is closed, but CKSAMPLE.APP continues to run.
Using a Database
Multiple databases can be stored on a single data source and a database can contain a number of tables. When you are connected to a data source, you can use a database on that source. To use the database whose data you want to access, choose Use Database... from the Database menu. The Use Database dialog opens. Type the name of the database you want to use in the text box and choose OK. To use a different database, follow the same steps. You can use only one database at a time. Once you use a database, the name of the database is displayed on the status bar and all the tables in that database are available for querying.
Creating a Query
You can allow CKSAMPLE.APP to build a SQL statement based on your choices in the Build Query dialog or write your own SQL statement in the Edit Query dialog.
Choose Build Query... from the Query menu to open the Build Query dialog. This dialog contains the following objects:
From... button -- Choose tables to be included in the query.
Choosing the From... button opens the From dialog with a list of the tables in the database currently in use and a list of tables from this database to be included in the query. To move a table from the Database tables list into the Query tables list, double-click it or select it with the mouse or keyboard and choose Add>>. To remove a table from the Query tables list, double-click it or select it with the mouse or keyboard and choose <<Remove. When the desired tables are in the Query tables list, choose OK. The chosen tables are displayed in the Build Query dialog.
Select... button -- Choose columns (fields) from the tables to be included in the query.
Choose the Select... button to open the Select dialog with a list of the columns in the tables selected in the From dialog and a list of columns from these tables to be included in the query. To move a table from the Database tables list into the Query tables list, double-click it or select it with the mouse or keyboard and choose Add>>. To remove a table from the Query tables list, double-click it or select it with the mouse or keyboard and choose <<Remove. When the desired tables are in the Query tables list, choose OK. The chosen tables are displayed in the Build Query dialog.
Join... button -- Specify join conditions for the tables in the query.
Choose the Join... button to open the Join dialog. Select the columns to be joined from the popups on the left and right sides of the dialog and the condition of the join from the center popup. A condition can be reversed by checking the NOT check box. Choose OK to complete the join or Cancel to leave the dialog without setting a join condition. If you include more than one table in a query, you should specify a join condition for every table. To specify additional join conditions, repeat the above steps.
Where... button -- Specify filter conditions for the query.
Choose the Where... button to open the Where dialog. Select the column to be filtered from the popup on the left side of the dialog and the condition of the filter from the center popup. Type the comparison number or string in the text box on the right side of the dialog.. A condition can be reversed by checking the NOT check box. Choose OK to set the filter or Cancel to leave the dialog without setting a filter condition.
Execute button -- Execute the query.
Edit... button -- Edit the SQL statement built in the Build Query dialog.
Choose the Edit... button to open the Edit dialog. The SQL statement built in the Build Query dialog is displayed in a text editing window so that you can customize the query. Choose the Execute button in the Edit dialog to execute the SQL statement. If you choose Cancel, the Edit dialog closes and the query is not executed.
Clear button -- Remove all tables, columns, join conditions, and filter conditions from the query being built.
Close button -- Close the Build Query dialog.
You can directly edit a SQL statement by choosing Edit Query... from the Query menu. This opens the Edit dialog box described above.
To execute a query already built, choose Execute Query from the Query menu
Setting Options
To set various options that affect the connection to the data source and the way in which result sets are processed, choose Options... from the Database menu. The Options dialog box opens with the following
objects:
Result Set -- Determine whether results are returned in cursors or tables.
Execution Mode -- Determine whether operations over the data source connection are processed synchronously, so that the entire procedure is performed before control is returned to CKSAMPLE.APP, or asynchronously, so that control is periodically returned to CKSAMPLE.APP.
Timeout (in seconds) -- Determine the length of time in seconds FoxPro will wait before timing out for a connection to be made or for a connection already made to respond.
Memo cutoff -- Determine the minimum length of a data source column for it to stored in a FoxPro table or cursor as a memo field. Columns shorter than the cutoff are stored as normal fields in a FoxPro table or cursor.
Display View window -- Displays the View window. The View window must be open to Convert a memo, which is described in the following section.
Converting a Memo
Data source memo columns can often contain binary information as well as text. Binary data is stored in general fields in FoxPro tables. To convert binary information from a data source query which has been stored to a memo field in a FoxPro table into a general type:
1. Make sure the View Window is open. You can open the View window by choosing Options... from the Database menu and choosing the Display View Window check box in the Options dialog box.
2. Make sure that result sets are returned in tables. If result sets are returned in cursors, you cannot convert memo fields to general fields.
3. Execute a SQL query that creates a table or cursor with a memo field. For information about executing a query, see the section titled CREATING A QUERY above.
4. Choose Convert Memo... from the Database menu.
5. Select the memo to convert in the Convert Memo dialog box and choose OK.
Exiting CKSAMPLE.APP
To Exit CKSAMPLE.APP, choose Exit from the Database menu. A dialog box with the following objects opens to confirm that you want to exit:
Yes button -- Choose to exit.
No button -- Return to CKSAMPLE.APP.
Close Tables on Exit check box -- Determine the state of tables after exit.
If Close Tables on Exit is checked, tables and cursors created by queries in CKSAMPLE.APP are closed when you leave CKSAMPLE.APP. If the result sets were stored to tables, you can open them again after you exit CKSAMPLE.APP. If the result sets were stored to cursors, they no longer exist when you exit CKSAMPLE.APP. To make result sets stored to cursors available after you exit CKSAMPLE.APP, uncheck the Close Tables on Exit check box.
t check box.
check box.
it CKSAMPLE.APP, uncheck the Close Tables on Exit check box.
The CKSAMPLE application lets you quickly and easily perform some of the basic operations associated with a client front end, such as connecting to a data source, using a database on the data source, and querying data. CKSAMPLE also lets you set various options, edit SQL commands to be sent to the data source, and convert a data source memo field with binary data to a FoxPro general type field.
Connecting to a Data Source
NOTE: Before you can connect to a data source, the appropriate driver for the data source must be installed on your machine.
When you run CKSAMPLE.APP, the Connect to Data Source dialog opens. This dialog contains the following objects:
Data Source text box -- Type the name of the data source to which you want to connect. This information is required in order to connect to a data source.
User Identifier text box -- Type the user identification under which you want to log on to the data source. This information is required in order to connect to a data source.
Password text box -- If the data source has password protection, type the password in this text box. If the data source doesn't require a password, you can leave this text box empty.
Connect String text box -- If the data source accepts an instruction or command when a connection is made, you can include that instruction in the Connect String text box. If the data source doesn't accept instructions or commands at the time of connection, text typed in the Connect String text box is ignored. This text box can be left empty.
OK and Cancel buttons -- Choose OK to attempt the connection specified in the various text boxes in this dialog. If the connection is successful, CKSAMPLE.APP displays a successful connection message in a wait window and the name of the data source on the status bar. If you the connection isn't successful, CKSAMPLE.APP displays a an error message and returns you to the dialog.
When you run CKSAMPLE.APP, you must connect to a data source. If you choose Cancel, CKSAMPLE.APP terminates.
To change data source connections, choose Disconnect from the Database menu, then choose Connect... from the Database menu. The Connect to Data Source dialog opens. Again, you need to indicate a data source to connect to and a user identification, as well as a password and connect string if desired, then choose OK. If you choose Cancel, no attempt is made to connect to a data source and the dialog is closed, but CKSAMPLE.APP continues to run.
Using a Database
More than one database can be stored on a single data source and a database can contain a number of tables. When you are connected to a data source, you can use a database on that source. To use the database whose data you want to access, choose Use Database... from the Database menu. The Use Database dialog opens. Type the name of the database you want to use in the text box and choose OK. To use a different database, follow the same steps. You can use only one database at a time. Once you use a database, the name of the database is displayed on the status bar and all the tables in that database are available for querying.
Creating a Query
You can build a SQL statement based on your choices in the Build Query dialog, or you can write your own SQL statement in the Edit Query dialog.
BUILD QUERY
Choose Build Query... from the Query menu to open the Build Query dialog. This dialog contains the following controls:
From... button -- Choose tables to be included in the query.
Choosing the From... button opens the From dialog with a list of the tables in the database currently in use and a list of tables from this database to be included in the query. To move a table from the Database tables list into the Query tables list, double-click it or select it with the mouse or keyboard and choose Add>>. To remove a table from the Query tables list, double-click it or select it and choose <<Remove. When you are finished constructing the Query tables list, choose OK. The chosen tables are displayed in the Build Query dialog.
Select... button -- Choose columns (fields) from the tables to be included in the query.
Choose the Select... button to open the Select dialog with a list of the columns in the tables selected in the From dialog and a list of columns from these tables to be included in the query. To move a column from the Columns of query tables list into the Columns to list list, double-click it or select it and choose Add>>. To remove a column from the Columns to list list, double-click it or select it and choose <<Remove. When you are finished constructing the Columns to list list, choose OK. The chosen columns are displayed in the Build Query dialog.
Join... button -- Specify join conditions for the tables in the query.
Choose the Join... button to open the Join dialog. Select the columns to be joined from the popups on the left and right sides of the dialog and the condition of the join from the center popup. You can reverse a condition by selecting the NOT check box. Choose OK to complete the join or Cancel to leave the dialog without setting a join condition. If you include more than one table in a query, you should specify a join condition for every table. To specify additional join conditions, repeat the above steps.
Where... button -- Specify filter conditions for the query.
Choose the Where... button to open the Where dialog. Select the column to be filtered from the popup on the left side of the dialog and the condition of the filter from the center popup. Type the comparison number or string in the text box on the right side of the dialog. You can reverse a condition by selecting the NOT check box. Choose OK to set the filter or Cancel to leave the dialog without setting a filter condition.
Execute button -- Execute the query.
Edit... button -- Enable you to edit the SQL statement built in the Build Query dialog.
Choose the Edit... button to open the Edit dialog. The SQL statement you built in the Build Query dialog is displayed in a text editing window so that you can customize the query. Choose the Execute button in the Edit dialog to execute the SQL statement. If you choose Cancel, the Edit dialog closes and the query isn't executed.
Clear button -- Remove all tables, columns, join conditions, and filter conditions from the query being built.
Close button -- Close the Build Query dialog.
EDIT QUERY
You can directly edit a SQL statement by choosing Edit Query... from the Query menu. This opens the Edit dialog box described above.
To execute a query already built, choose Execute Query from the Query menu
Setting Options
To set various options that affect the connection to the data source and the way in which result sets are processed, choose Options... from the Database menu. The Options dialog box opens with the following items:
Result Set -- Determine whether results are returned in cursors or tables.
Execution Mode -- Determine whether operations over the data source connection are processed synchronously, so that the entire procedure is performed before control is returned to CKSAMPLE.APP, or asynchronously, so that control is periodically returned to CKSAMPLE.APP.
Timeout (in seconds) -- Determine the length of time in seconds FoxPro will wait for a connection to be made or for a connection already made to respond.
Memo cutoff -- Determine the minimum length of a data source column for it to be stored in a FoxPro table or cursor as a memo field. Columns shorter than the cutoff are stored as normal fields in a FoxPro table or cursor.
Display View window -- Displays the View window. The View window must be open to Convert a memo.
Converting a Memo
Data source memo columns can often contain binary information as well as text. Before binary data received from a data source can be manipulated in FoxPro, the memo field in the FoxPro table containing the binary data must be converted to a general type field. To convert a memo field in a FoxPro table into a general type:
1. Make sure the View Window is open. You can open the View window by choosing Options... from the Database menu and choosing the Display View Window check box in the Options dialog box.
2. Make sure that result sets are returned in tables. If result sets are returned in cursors, you cannot convert memo fields to general fields.
3. Execute a SQL query that creates a table or cursor with a memo field. For information about executing a query, see the section titled Creating a Query above.
4. Choose Convert Memo... from the Database menu.
5. Select the memo to convert in the Convert Memo dialog box and choose OK.
Exiting CKSAMPLE.APP
To Exit CKSAMPLE.APP, choose Exit from the Database menu. A dialog box with the following objects opens to confirm that you want to exit:
Yes button -- Choose to exit.
No button -- Return to CKSAMPLE.APP.
Close Tables on Exit check box -- Determine the state of tables after exit.
If Close Tables on Exit is checked, tables and cursors created by queries in CKSAMPLE.APP are closed when you leave CKSAMPLE.APP. If the result sets were stored to tables, you can open them again after you exit CKSAMPLE.APP. If the result sets were stored to cursors, they no longer exist when you exit CKSAMPLE.APP. To make result sets stored to cursors available after you exit CKSAMPLE.APP, uncheck the Close Tables on Exit check box.
heck the Close Tables on Exit check box.
"Query executing" TIMEOUT 1
EN
The CKSAMPLE.APP application lets you quickly and easily perform some of the basic operations associated with a client front end, such as connecting to a data source, using a database on the data source, and querying data. CKSAMPLE.APP also lets you set various options, edit SQL commands to be sent to the data source, and convert a data source memo field containing binary data to a FoxPro general type field.
Connecting to a Data Source
NOTE: Before you can connect to a data source, the appropriate driver for the data source must be installed on your machine.
When you run CKSAMPLE.APP, the Connect to Data Source dialog opens. This dialog contains the following objects:
Data Source text box -- Type the name of the data source to which you want to connect. This information is required in order to connect to a data source.
User Identifier text box -- Type the user identification under which you want to log on to the data source. This information is required in order to connect to a data source.
Password text box -- If the data source has password protection, type the password in this text box. If the data source doesn't require a password, you can leave this text box empty.
Connect String text box -- If the data source accepts an instruction or command when a connection is made, you can include that instruction in the Connect String text box. If the data source doesn't accept instructions or commands at the time of connection, text typed in the Connect String text box is ignored. This text box can be left empty.
OK and Cancel buttons -- Choose OK to attempt the connection specified in the various text boxes in this dialog. If the connection is successful, CKSAMPLE.APP displays a successful connection message in a wait window and the name of the data source on the status bar. If you the connection isn't successful, CKSAMPLE.APP displays a an error message and returns you to the dialog.
When you run CKSAMPLE.APP, you must connect to a data source. If you choose Cancel, CKSAMPLE.APP terminates.
To change data source connections, choose Disconnect from the Database menu, then choose Connect... from the Database menu. The Connect to Data Source dialog opens, and you again need to indicate a data source to connect to and a user identification, as well as a password and connect string if desired, then choose OK. If you choose Cancel, no attempt is made to connect to a data source and the dialog is closed, but CKSAMPLE.APP continues to run.
Using a Database
More than one database can be stored on a single data source and a database can contain a number of tables. When you are connected to a data source, you can use a database on that source. To use the database whose data you want to access, choose Use Database... from the Database menu. The Use Database dialog opens. Type the name of the database you want to use in the text box and choose OK. To use a different database, follow the same steps. You can use only one database at a time. Once you use a database, the name of the database is displayed on the status bar and all the tables in that database are available for querying.
Creating a Query
You can build a SQL statement based on your choices in the Build Query dialog, or you can write your own SQL statement in the Edit Query dialog.
BUILD QUERY
Choose Build Query... from the Query menu to open the Build Query dialog. This dialog contains the following controls:
From... button -- Choose tables to be included in the query.
Choosing the From... button opens the From dialog with a list of the tables in the database currently in use and a list of tables from this database to be included in the query. To move a table from the Database tables list into the Query tables list, double-click the name of the table or select it with the mouse or keyboard and choose Add>>. To remove a table from the Query tables list, double-click the name of the table or select it and choose <<Remove. When you are finished constructing the Query tables list, choose OK. The chosen tables are displayed in the Build Query dialog.
Select... button -- Choose columns (fields) from the tables to be included in the query.
Choose the Select... button to open the Select dialog with a list of the columns in the tables selected in the From dialog and a list of columns from these tables to be included in the query. To move a column from Columns of query tables into Columns to list, double-click the name of the column or select it and choose Add>>. To remove a column from Columns to list, double-click the name of the column or select it and choose <<Remove. When you are finished constructing the list in Columns to list, choose OK. The chosen columns are displayed in the Build Query dialog.
Join... button -- Specify join conditions for the tables in the query.
Choose the Join... button to open the Join dialog. Select the columns to be joined from the popups on the left and right sides of the dialog and the condition of the join from the center popup. You can reverse a condition by selecting the NOT check box. Choose OK to complete the join or Cancel to leave the dialog without setting a join condition. If you include more than one table in a query, you should specify a join condition for every table. To specify additional join conditions, repeat the above steps.
Where... button -- Specify filter conditions for the query.
Choose the Where... button to open the Where dialog. Select the column to be filtered from the popup on the left side of the dialog and the condition of the filter from the center popup. Type the comparison number or string in the text box on the right side of the dialog. You can reverse a condition by selecting the NOT check box. Choose OK to set the filter or Cancel to leave the dialog without setting a filter condition.
Execute button -- Execute the query.
Edit... button -- Enable you to edit the SQL statement built in the Build Query dialog.
Choose the Edit... button to open the Edit dialog. The SQL statement you built in the Build Query dialog is displayed in a text editing window so that you can customize the query. Choose the Execute button in the Edit dialog to execute the SQL statement. If you choose Cancel, the Edit dialog closes and the query isn't executed.
Clear button -- Remove all tables, columns, join conditions, and filter conditions from the query being built.
Close button -- Close the Build Query dialog.
EDIT QUERY
You can directly edit a SQL statement by choosing Edit Query... from the Query menu. This opens the Edit dialog box described above.
To execute a query already built, choose Execute Query from the Query menu.
Setting Options
To set various options that affect the connection to the data source and the way in which result sets are processed, choose Options... from the Database menu. The Options dialog box opens with the following:
Result Set -- Determine whether results are returned in cursors or tables.
Execution Mode -- Determine whether operations over the data source connection are processed synchronously, so that the entire procedure is performed before control is returned to CKSAMPLE.APP, or asynchronously, so that control is periodically returned to CKSAMPLE.APP.
Timeout (in seconds) -- Determine the length of time in seconds FoxPro waits for a connection to be made or for a connection already made to respond.
Memo cutoff -- Determine the minimum length of a data source column for it to be stored in a FoxPro table or cursor as a memo field. Columns shorter than the cutoff are stored as normal fields in a FoxPro table or cursor.
Display View window -- Displays the View window. The View window must be open to Convert a memo.
Converting a Memo
Data source memo columns can often contain binary information as well as text. Before binary data received from a data source can be manipulated in FoxPro, the memo field in the FoxPro table containing the binary data must be converted to a general type field. To convert a memo field in a FoxPro table into a general type:
1. Make sure the View Window is open. You can open the View window by choosing Options... from the Database menu and choosing the Display View Window check box in the Options dialog box.
2. Make sure that result sets are returned in tables. If result sets are returned in cursors, you cannot convert memo fields to general fields.
3. Execute a SQL query that creates a table with a memo field. For information about executing a query, see the section titled Creating a Query above.
4. Choose Convert Memo... from the Database menu.
5. Select the memo to convert in the Convert Memo dialog box and choose OK.
Exiting CKSAMPLE.APP
To Exit CKSAMPLE.APP, choose Exit from the Database menu. A dialog box with the following objects opens to confirm that you want to exit:
Yes button -- Choose to exit.
No button -- Return to CKSAMPLE.APP.
Close Tables on Exit check box -- Determine the state of tables after exit.
As long as the Close Tables on Exit check box is selected, tables and cursors created by queries in CKSAMPLE.APP are closed when you leave CKSAMPLE.APP. If the result sets were stored to tables, you can open them again after you exit CKSAMPLE.APP. If the result sets were stored to cursors, they no longer exist when you exit CKSAMPLE.APP. To make result sets stored to cursors available after you exit CKSAMPLE.APP, clear the Close Tables on Exit check box.
The CKSAMPLE.APP application lets you quickly and easily perform some of the basic operations associated with a client front end, such as connecting to a data source, using a database on the data source, and querying data. CKSAMPLE.APP also lets you set various options, edit SQL commands to be sent to the data source, and convert a data source memo field containing an OLE object to a FoxPro general type field.
Connecting to a Data Source
NOTE: Before you can connect to a data source, the appropriate driver for the data source must be installed on your machine.
When you run CKSAMPLE.APP, the Connect to Data Source dialog box opens. This dialog box contains the following objects:
Data Source text box -- Type the name of the data source to which you want to connect. This information is required in order to connect to a data source.
User Identifier text box -- Type the user identification under which you want to log on to the data source. This information is required in order to connect to a data source.
Password text box -- If the data source has password protection, type the password in this text box. If the data source doesn't require a password, you can leave this text box empty.
Connect String text box -- If the data source accepts an instruction or command when a connection is made, you can include that instruction in the Connect String text box. If the data source doesn't accept instructions or commands at the time of connection, text typed in the Connect String text box is ignored. This text box can be left empty.
OK and Cancel buttons -- Choose OK to attempt the connection specified in the various text boxes in this dialog box. If the connection is successful, CKSAMPLE.APP displays a successful connection message in a wait window and the name of the data source on the status bar. If the connection isn't successful, CKSAMPLE.APP displays an error message and returns you to the dialog box.
When you run CKSAMPLE.APP, you must connect to a data source. If you choose Cancel, CKSAMPLE.APP terminates.
To change data source connections, choose Disconnect from the Database menu, then choose Connect... from the Database menu. The Connect to Data Source dialog box opens, and you again need to indicate a data source to connect to and a user identification, as well as a password and connect string if desired, then choose OK. If you choose Cancel, no attempt is made to connect to a data source and the dialog box is closed, but CKSAMPLE.APP continues to run.
Using a Database
More than one database can be stored on a single data source and a database can contain a number of tables. When you are connected to a data source, you can use a database on that source. To use the database whose data you want to access, choose Use Database... from the Database menu. The Use Database dialog box opens. Type the name of the database you want to use in the text box and choose OK. To use a different database, follow the same steps. You can use only one database at a time. Once you use a database, the name of the database is displayed on the status bar and all the tables in that database are available for querying.
Creating a Query
You can build a SQL statement based on your choices in the Build Query dialog box, or you can write your own SQL statement in the Edit Query dialog box.
BUILD QUERY
Choose Build Query... from the Query menu to open the Build Query dialog box. This dialog box contains the following controls:
From... button -- Choose tables to be included in the query.
Choosing the From... button opens the From dialog box with a list of the tables in the database currently in use and a list of tables from this database to be included in the query. To move a table from the Database tables list into the Query tables list, double-click the name of the table or select it with the mouse or keyboard and choose Add>>. To remove a table from the Query tables list, double-click the name of the table or select it and choose <<Remove. When you are finished constructing the Query tables list, choose OK. The chosen tables are displayed in the Build Query dialog box.
Select... button -- Choose columns (fields) from the tables to be included in the query.
Choose the Select... button to open the Select dialog box with a list of the columns in the tables selected in the From dialog box and a list of columns from these tables to be included in the query. To move a column from Columns of query tables into Columns to list, double-click the name of the column or select it and choose Add>>. To remove a column from Columns to list, double-click the name of the column or select it and choose <<Remove. When you are finished constructing the list in Columns to list, choose OK. The chosen columns are displayed in the Build Query dialog box.
Join... button -- Specify join conditions for the tables in the query.
Choose the Join... button to open the Join dialog box. Select the columns to be joined from the popups on the left and right sides of the dialog box and the condition of the join from the center popup. You can reverse a condition by selecting the NOT check box. Choose OK to complete the join or Cancel to leave the dialog box without setting a join condition. If you include more than one table in a query, you should specify a join condition for every table. To specify additional join conditions, repeat the above steps.
Where... button -- Specify filter conditions for the query.
Choose the Where... button to open the Where dialog box. Select the column to be filtered from the popup on the left side of the dialog box and the condition of the filter from the center popup. Type the comparison number or string in the text box on the right side of the dialog box. You can reverse a condition by selecting the NOT check box. Choose OK to set the filter or Cancel to leave the dialog box without setting a filter condition.
Execute button -- Execute the query.
Edit... button -- Enable you to edit the SQL statement built in the Build Query dialog box.
Choose the Edit... button to open the Edit dialog box. The SQL statement you built in the Build Query dialog box is displayed in a text editing window so that you can customize the query. Choose the Execute button in the Edit dialog box to execute the SQL statement. If you choose Cancel, the Edit dialog box closes and the query isn't executed.
Clear button -- Remove all tables, columns, join conditions, and filter conditions from the query being built.
Close button -- Close the Build Query dialog box.
EDIT QUERY
You can directly edit a SQL statement by choosing Edit Query... from the Query menu. This opens the Edit dialog box box described above.
To execute a query already built, choose Execute Query from the Query menu.
Setting Options
To set various options that affect the connection to the data source and the way in which result sets are processed, choose Options... from the Database menu. The Options dialog box box opens with the following:
Result Set -- Determine whether results are returned in cursors or tables.
Execution Mode -- Determine whether operations over the data source connection are processed synchronously, so that the entire procedure is performed before control is returned to CKSAMPLE.APP, or asynchronously, so that control is periodically returned to CKSAMPLE.APP.
Timeout (in seconds) -- Determine the length of time in seconds FoxPro waits for a connection to be made or for a connection already made to respond.
Memo cutoff -- Determine the minimum length of a data source column for it to be stored in a FoxPro table or cursor as a memo field. Columns shorter than the cutoff are stored as normal fields in a FoxPro table or cursor.
Display View window -- Displays the View window. The View window must be open to Convert a memo.
Converting a Memo
Data source memo columns can often contain binary information as well as text. Before binary data received from a data source can be manipulated in FoxPro, the memo field in the FoxPro table containing the binary data must be converted to a general type field. To convert a memo field in a FoxPro table into a general type:
1. Make sure the View Window is open. You can open the View window by choosing Options... from the Database menu and choosing the Display View Window check box in the Options dialog box box.
2. Make sure that result sets are returned in tables. If result sets are returned in cursors, you cannot convert memo fields to general fields.
3. Execute a SQL query that creates a table with a memo field. For information about executing a query, see the section titled Creating a Query above.
4. Choose Convert Memo... from the Database menu.
5. Select the memo to convert in the Convert Memo dialog box box and choose OK.
Exiting CKSAMPLE.APP
To Exit CKSAMPLE.APP, choose Exit from the Database menu. A dialog box box with the following objects opens to confirm that you want to exit:
Yes button -- Choose to exit.
No button -- Return to CKSAMPLE.APP.
Close Tables on Exit check box -- Determine the state of tables after exit.
As long as the Close Tables on Exit check box is selected, tables and cursors created by queries in CKSAMPLE.APP are closed when you leave CKSAMPLE.APP. If the result sets were stored to tables, you can open them again after you exit CKSAMPLE.APP. If the result sets were stored to cursors, they no longer exist when you exit CKSAMPLE.APP. To make result sets stored to cursors available after you exit CKSAMPLE.APP, clear the Close Tables on Exit check box.
TALKz
COMPATIBLEz
READBORDERz
mem2gen
MEM2GEN
MEM2GEN.PJX
MEM2GEN
MEM2GEN.SCX
MEM2GEN
MEM2GEN.MNX
MEM2GEN
MEM2GEN.PRG
MEM2GEN
MEM2GEN.FRX
MEM2GEN
MEM2GEN.QPR
MS Sans Serif
Convert Memo
Not a Table (a cursor perhaps)
Select a Table
mytable
mytable
tempmf
No memo fields to convert!
There are no OLE objects in this table!
mem2gen
Please select a memo to convert:
MS Sans Serif
@ 1.923,3.400 GET mselect PICTURE "@&T" FROM thememos SIZE 12.692,37.400 DEFAULT 1 FONT "MS Sans Serif", 8
(.txt)