SQLitening Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Welcome to the SQLitening support forums!

Author Topic: declares  (Read 1526 times)

D. Wilson

  • Guru
  • ***
  • Posts: 196
    • View Profile
declares
« on: July 31, 2012, 01:28:32 PM »

There are some new functions in version 1.6. I do not see these functions in the inc file. I am using the 'special' inc file
Do I apply these function to the server or client. . The calls I am inquiring about is slIsDatabaseNameValid and slIsTableNameValid.
Logged

Fred Meier

  • Master Geek
  • ****
  • Posts: 806
    • View Profile
Re: declares
« Reply #1 on: July 31, 2012, 03:24:00 PM »

Oops, I forgot to add those two new funtions to the Sepecial and Universial API's.  I wll add and post them ASAP.
Logged

D. Wilson

  • Guru
  • ***
  • Posts: 196
    • View Profile
Re: declares
« Reply #2 on: July 31, 2012, 04:08:13 PM »

Much appreciated. Thanks for the fast response
Logged

Fred Meier

  • Master Geek
  • ****
  • Posts: 806
    • View Profile
Re: declares
« Reply #3 on: August 02, 2012, 03:36:37 PM »

I have added the two new functions. You may download here http://www.sqlitening.com/support/index.php?topic=3468.0
Logged

cj

  • Master Geek
  • ****
  • Posts: 653
    • View Profile
IsTableNameValid - SQLitening.Inc OPTIONAL removed
« Reply #4 on: March 13, 2018, 08:38:16 AM »

IsTableNameValid  - SQLitening.Inc OPTIONAL removed
This probably affects the other interfaces.

REM DECLARE FUNCTION slIsTableNameValid LIB "SQLitening.Dll" ALIAS "slIsTableNameValid" (BYVAL rsTableName AS STRING, OPTIONAL BYVAL rsDatabaseName AS STRING) AS LONG

Change to:
DECLARE FUNCTION slIsTableNameValid LIB "SQLitening.Dll" ALIAS "slIsTableNameValid" (BYVAL rsTableName AS STRING) AS LONG

SQLitening.BAS/DLL does not accept accept a second parameter so it should be removed from the DECLARE


Here is slIsTableNameValid in SQLitening.bas (notice no second parameter is accepted)

'======================<[ Is Table Name Valid ]>=======================
FUNCTION slIsTableNameValid ALIAS "slIsTableNameValid" (BYVAL rsTableName AS STRING)EXPORT AS LONG
'   Returns %True if TableName is valid(exist, has been created). Returns
'   %False if it is not valid. If two or more tables in different databases
'   have the same name, add the database-name prefix.

   IF LEN(slGetTableColumnNames(rsTableName)) THEN FUNCTION = %True

END FUNCTION

Bern Ertl

  • Master Geek
  • ****
  • Posts: 485
  • Excellent
    • View Profile
    • InterPlan Systems
Re: declares
« Reply #5 on: March 14, 2018, 08:57:27 AM »

Thanks cj. Good catch.