SQLitening Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Welcome to the SQLitening support forums!

Pages: 1 2 [3] 4 5 ... 10
 21 
 on: November 20, 2018, 03:26:59 AM 
Started by Fim - Last post by Fim
Paul,
That's what I've solved now.
/Fim

 22 
 on: November 19, 2018, 03:27:23 PM 
Started by Fim - Last post by Paul Squires
Create table #61 and put your table descriptions there. Two fields... table name, table description.

 23 
 on: November 19, 2018, 12:07:19 PM 
Started by Fim - Last post by Fim
Thanks,
I'll skip it all.
/Fim W

 24 
 on: November 19, 2018, 10:48:44 AM 
Started by Fim - Last post by cj
No problem unless:
“The VACUUM command may change the ROWIDs of entries in any tables that do not have an explicit INTEGER PRIMARY KEY.”

 25 
 on: November 19, 2018, 07:40:22 AM 
Started by Fim - Last post by Fim
I have a database of just over 60 tables. The names are always 3 letters, such as ARB, ART, FAB. Now I intend to insert a table description in each table on rowid = 0.
Is it good or bad?
/Fim W.

 26 
 on: November 05, 2018, 01:23:47 PM 
Started by Fredrick Ughimi - Last post by Fredrick Ughimi
Hello CJ,

I mistakenly was changing the values of the same Database in another directory. My mistake.

Works great! Thanks once again.

 27 
 on: November 05, 2018, 10:14:22 AM 
Started by Fredrick Ughimi - Last post by Fredrick Ughimi
Yes. I understand the values are read into aData array.
Code: [Select]
aData(x-1) = VAL(sArray(x)) read each value into the aData array

Just that the values in my table doesn't reflect what the Chart says. Maybe I am doing something wrong. I would check.

Thanks a lot.

 28 
 on: November 05, 2018, 09:51:28 AM 
Started by Fredrick Ughimi - Last post by cj
Quote
Excellent. Thanks for the sample code. The problem is how do I individually read each values into the
aData array subscripts.
aData(0) = ? : aData(1) = ? : aData(2) = ? : aData(3) = ? : aData(4) = ?

The code did this so don't understand the question?   
aData(0) = row 1 temperature as a DOUBLE
aData(1) = row 2 temperature as a DOUBLE
aData(2) = row 3 temperature as a DOUBLE
aData(3) = row 4 temperature as a DOUBLE
aData(4) = row 5 temperature as a DOUBLE

REDIM sArray(0) AS STRING
slSelAry "select temperature from table1 LIMIT 5",sArray(),"Q9"
elements = UBOUND(sArray)
IF elements > 0 THEN
REDIM aData(elements) AS DOUBLE
 FOR x = 1 TO elements
  aData(x-1) = VAL(sArray(x)) read each value into the aData array subscript.
 NEXT
END IF

 29 
 on: November 05, 2018, 09:03:25 AM 
Started by Fredrick Ughimi - Last post by Fredrick Ughimi
Hello CJ,

Excellent. Thanks for the sample code. The problem is how do I individually read each values into the
aData array subscripts.

aData(0) = ? : aData(1) = ? : aData(2) = ? : aData(3) = ? : aData(4) = ?

Best regards.


 30 
 on: November 04, 2018, 09:09:12 PM 
Started by Fredrick Ughimi - Last post by cj
#INCLUDE "sqlitening.inc"

FUNCTION PBMAIN () AS LONG
 LOCAL x,elements AS LONG

 slOpen "junk.db3","C"
 slexe "drop table if exists table1
 slexe "create table if not exists table1(temperature integer)"
 slexe "insert into table1(temperature)values(30),(40),(70),(60),(20),(17),(88)"

 REDIM sArray(0) AS STRING
 slSelAry "select temperature from table1",sArray(),"Q9"

 'read each value into the aData array subscript.
 elements = UBOUND(sArray)
 IF elements > 0 THEN
  REDIM aData(elements) AS DOUBLE
  FOR x = 1 TO elements
   aData(x-1) = VAL(sArray(x))
  NEXT
 END IF
END FUNCTION


Pages: 1 2 [3] 4 5 ... 10