WinDev Source Code

HyperFileSQL, Find a record
---------------------------
HReadSeekFirst(My_HR,nama,EDT_Nama)
IF HFound() THEN
Info("Record found")
ELSE
Error("No record found")
END

...
HReadSeekFirst(table_name,field_name,text_name)
...

=====================================================
List of functions - HyperFileSQL Client/Server engine
=====================================================
The following functions are used to manage the HyperFileSQL Client/Server engine:

HActivateServerTrigger
Re-enables a trigger previously disabled by HDeleteServerTrigger.

HAddGroup
Adds a group of users. All the characteristics of the group must be entered in the variables for group management.

HAddLink
Adds an integrity rule between two files on the server. This integrity rule was previously described by a Link Description variable. All the client applications must comply with these integrity rules.

HAddTask
Adds a scheduled task to the server defined by the connection. This task was defined by an advanced variable of hScheduledTask type.

HAddUser
Adds a user to a database. All the characteristics of the user must be entered in the variables for user management.

HBackup
Saves the content of a HyperFileSQL server: all the databases found on the server, one or more databases, one or more files. This backup can be performed while one or more databases are being used.

HCancelBackup
Cancels a backup in progress.

HClearWorkingDir
Clears and destroys the temporary directory previously created during the execution of HServerWorkingDir.

HCopyFile
Copies a HyperFileSQL file (.fic, .ndx and .mmo files if they exist):

from the HyperFileSQL server to the server (to perform a backup for instance).

from the HyperFileSQL server to the client computer (to perform a local backup for instance).

from the client computer to the HyperFileSQL server (to update the files for instance)

HDeactivateServerTrigger
Disables a HyperFileSQL Client/Server server trigger. This trigger can be re-enabled by HActivateServerTrigger.

HDeleteBackup
Deletes a backup previously performed by HBackup. The backup is physically deleted from the disk.

HDeleteDatabase
Deletes a database found on a HyperFileSQL server. All the connections that use the deleted database are closed.

HDeleteFile
Deletes the HyperFileSQL files (.fic, .ndx and .mmo files if they exist) from the server.

HDeleteGroup
Deletes (from the server) a group of users associated with a connection.

HDeleteLink
Deletes an integrity rule between two files on the server. The integrity rule to delete is defined by a Link Description variable.

HDeleteParameter
Deletes a parameter that was previously saved by HSaveParameter.

HDeleteQuery
Deletes a query from a HyperFileSQL server.

HDeleteServerTrigger
Destroys a server trigger. This server trigger cannot be used anymore.

HDeleteSet
Deletes a set of stored procedures from a HyperFileSQL server.

HDeleteTask
Deletes a scheduled task from a HyperFileSQL Client/Server server.

HDeleteUser
Deletes (from the server) a user associated with a connection.

HDescribeServerTrigger
Adds or modifies a server trigger. A server trigger is a stored procedure automatically called by the HyperFileSQL engine whenever a HyperFileSQL function is run.

HDisconnectClient
Displays a message on the client computers and disconnects the application.

HEndNoDatabaseAccess
Re-authorizes the access to one or more databases accessible via a connection.

HExecuteProcedure
Runs a stored procedure or function.

HInfoBackup
Returns information about one or more backups performed on a HyperFileSQL Client/Server server.

HInfoDatabaseProperty
Enables you to find out the properties of a database found on a HyperFileSQL server.

HInfoDatabaseRights
Enables you to find out the rights granted to a user or to a group on a database.

HInfoFile
Returns the characteristics of a file located on a HyperFileSQL server.

HInfoFileProperty
Enables you to find out the properties of a data file found on a HyperFileSQL server.

HInfoFileRights
Enables you to find out the rights granted to a user or a group for a data file.

HInfoGroup
Returns information about the specified group of users. This information is automatically assigned to the variables for group management.

HInfoLock
Returns information about a lock performed on a file, on a record or on all the records found in a file.

HInfoLog
Returns information about the server logs.

HInfoServer
Returns the specified information about a server. The server corresponds to the computer where the connection is performed.

HInfoServerProperty
Enables you to find out the properties of a HyperFileSQL server.

HInfoServerRights
Enables you to find out the rights granted to a user or to a group on a server. The server used was defined in the connection.

HInfoTask
Returns the characteristics of a scheduled task in an advanced variable of hScheduledTask type.

HInfoUser
Refreshes the variables for user management with the information about the specified user.

HListConnectedUser
Returns the list of users currently connected to one or more files handled by a Client/Server connection.

HListDatabase
Lists the Client/Server databases associated with a connection.

HListGroup
Returns the list of groups of users defined for a connection.

HListParameter
Returns the list of parameters saved from the stored procedures on the server.

HListServerTrigger
Returns the list of available triggers on a connection or on one of the files of the connection.

HListStoredElement
Returns the list of elements stored on a HyperFileSQL server (sets of procedures, stored procedures or queries).

HListTask
Returns the list of scheduled tasks found on a server.

HListUser
Returns the list of users defined for a connection.

HLoadParameter
Reads a parameter that was previously saved from a stored procedure by HSaveParameter.

HManageTask
Enables or disables a scheduled task on a HyperFileSQL Client/Server server. This function can also be used to find out the status of a scheduled task.

HModifyDatabaseProperty
Modifies the properties of a database found on a HyperFileSQL server.

HModifyDatabaseRights
Modifies the rights granted to a user or to a group for a HyperFileSQL Client/Server database.

HModifyFileProperty
Modifies the properties of a HyperFileSQL file found on a server.

HModifyFileRights
Modifies the rights granted to a user or to a group for a HyperFileSQL Client/Server data file.

HModifyGroup
Modifies the group information according to the elements found in the corresponding variables for group management.

HModifyServerProperty
Modifies the properties of a HyperFileSQL server.

HModifyServerRights
Modifies the rights granted to a user or to a group on a HyperFileSQL server.

HModifyTask
Modifies a scheduled task on the server defined by the connection. This task is found in an advanced variable of hScheduledTask type.

HModifyUser
Modifies the user information according to the elements found in the corresponding variables for user management.

HNoDatabaseAccess
Forbids all the accesses to a database or to all the databases accessible via a connection.

HOnServerCall
Customizes the management of message display on the client computer and the management of disconnection from a client computer.

HPriority
Used to find out and modify the priority of the calling application.

HPriorityClient
Modifies the priority of a client application

HReconnect
Performs a reconnection to the server for all the interrupted connections.

HRefreshQuery
Creates or refreshes a query on a HyperFileSQL server

HRefreshSet
Creates or refreshes a set of procedures on a HyperFileSQL server

HResetClient
Initializes the structure for managing the client computers (HClient structure).

HResetGroup
Initializes the variables for group management with the default values.

HResetUser
Initializes the variables for user management with the default values.

HRestoreBackup
Used to restore a backup performed by HBackup (or via the HyperFileSQL Control Center).

HRetrieveLog
Retrieves from a file the server logs performed between two given dates

HSaveParameter
Saves a persistent value from a stored procedure. This value can be read by HLoadParameter.

HSendMessageToClient
Displays a message on the client computers. The affected client computers are the computers listed in the HClient structure.

HServerStatus
Used to find out the status of a server.

HServerWorkingDir
Returns the path of a temporary directory on the server. This directory is automatically created on the server. The stored procedures run on the server will have the rights to write into this directory. This directory will be automatically cleared and destroyed during the disconnection of the client.

HSetCache
Enables you to configure the management of caches in the HyperFileSQL Client/Server engine.

HSetServer
Used to modify some parameters of the server.

HStartServer
Used to start a server (uses MantaManager).

HStopServer
Stops a server. To perform this action, the user must have sufficient rights on the server.

HTransactionList
Returns the list of current or interrupted transactions found on the server for the specified connection.

WINDEV: You too can develop 10 times faster

What type of applications can I develop?

Any type! Payroll, industrial, medical, inventory, EDI, CAE, ERP, CRM, EAI,
back and front Office, .NET, Web services, catalogs, etc.
There is no limit.

http://www.windev.es/windev/broch9/

WebDev solutions

http://www.windev.com/webdev/

http://www.windev.com/pcsoft/videos.html

Filling A Table Programmatically Using A Query

link : http://forum.pcsoft.fr/thread.awp?groupid=pcsoft.us.windev&postid=195981&cur=195981&lang=en-us&v=2

Thank you for your answer. I did as you suggested and made sure that the combo control value and the edit control value are being seen. They are.

The code in the button is set to execute a query. It clears the table, sets up the parameter values, executes the query and loads the table. However, I see that the table has the names requested using a LIKE but it is not sorted by region, district and name as requested. As I scroll farther down, I see that actually ALL the records (including those not requested) have been loaded. I am selecting based upon PARAM1 (status of Activo, Inactivo or Pasivo) and PARAM2 (name entered to match a LIKE pattern).

The button's code is as follows:
CODE
TableDeleteAll(TABLE_Table1)
Subscript is int
Str is string
Subscript = ListSelect(COMBO_Status)
Str = COMBO_Status[Subscript]
QRY_Query1.Param1 = Str
QRY_Query1.Param2 = EDT_Criteria
Info(QRY_Query1.Param1)
Info(QRY_Query1.Param2)
HExecuteQuery(QRY_Query1,MyConnection1,QRY_Query1.Param1,QRY_Query1.Param2)
HReadSeek(students,nombre,EDT_Criteria)
IF HFound(students) THEN
SUB is int = 1
LOOP
TableAddLine(TABLE_Table1,students.reckey,students.nombre,students.fecha_nac,students.registro,students.fecha_regi,students.regiones,students.distrito,students.referidopor,students.status)
HReadNext(students,nombre)
IF HOut(students) = True THEN
BREAK
ELSE
TableAddLine(TABLE_Table1,COL_Column1,COL_Column2,COL_Column3,COL_Column4,COL_Column5,COL_Column6,COL_Column7,COL_Column8,COL_Column9)
SUB += 1
END
END
END
/CODE

The query is as follows:
SELECT
students.reckey AS reckey,
students.nombre AS nombre,
students.fecha_nac AS fecha_nac,
students.registro AS registro,
students.fecha_regi AS fecha_regi,
students.regiones AS regiones,
students.distrito AS distrito,
students.referidopor AS referidopor,
students.status AS status
FROM
students
WHERE
students.status = {Param1}
AND students.nombre LIKE {Param2}%
ORDER BY
reckey ASC,
distrito ASC,
nombre ASC

Why am I getting everything in the table?

Thanks for your help.
Vince

Reference tutorial windev

forum
----
http://www.ozdev.net/index.php?t=selmsg&&frm_id=0&reply_count=0&mr=1&start=60

new soultion
============

http://forum.mysnip.de/list.php?27161



http://courgratuit.blogspot.com/2009/02/windev-tutorial-complet.html

http://www.sdaughtry.com/documents/windev.html
http://www.windevtutorials.com/syshotkey2.html

http://www.helpconsulting.net/wd/colrpt7.html

http://www.youtube.com/watch?v=8AEH8-N0yH8&feature=channel_page
http://www.youtube.com/profile?user=PCSOFTdotFR&view=videos&start=180