• Welcome to SQLitening Support Forum.
 

News:

Welcome to the SQLitening support forums!

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - cj

#1
No problem using any delimiter with binding

create table t1(c1)
sRecord = CHR$("A",delimiter,"B",delimiter,"C")
slExeBind "insert into t1 values(?)",slBuildBindDat(sRecord)












#2
https://sqlite.org/forum/forumpost/d6aaaee4a5
#INCLUDE ONCE "sqlitening.inc"  'Anything.bas with binding so keys can be anything
MACRO bind(str) = slBuildbindDat(str,"T")

FUNCTION PBMAIN AS LONG
LOCAL sWord,sdata AS STRING
slOpen "words.db3","C"
'slexe  "drop table if exists WordTable;drop table if exists PointerTable" 'start over
slexe  "create table if not exists WordTable(Word text primary key,Pointers text) without rowid"
slexe  "create table if not exists PointerTable(HighPointer integer)
IF LEN(slSelStr("Select * from PointerTable"))=0 THEN slexe "insert into PointerTable values(0)"
DO
  sdata = GetRecordSet("Select * from WordTable")
  sWord = INPUTBOX$(sdata,"Insert word",sWord)
  IF LEN(sWord) = 0 THEN EXIT DO
  slexe "begin immediate"
  AddWord sWord
  slexe "end"
LOOP
END FUNCTION
'=====================================================================================
FUNCTION AddWord(sWord AS STRING) AS STRING
LOCAL sHighPointer AS STRING

'increment pointertable.highpointer
sHighPointer = FORMAT$(VAL(slSelStr("Select HighPointer from PointerTable limit 1"))+1)
slexebind  "update PointerTable set HighPointer=?",bind(sHighPointer)

'search wordtable.word for sWord
slSelBind  "Select Word,Pointers from WordTable where Word=?", bind(sWord)

IF slGetRow THEN 'update wordtable pointers column
  slexebind "update WordTable set Pointers = ? where Word = ?",bind(slf(2)+ "," + sHighPointer) + bind(sWord)
ELSE            'insert wordtable
  slexebind "insert into WordTable values(?,?)",bind(sWord)+bind(sHighPointer)
END IF
END FUNCTION
'=====================================================================================
FUNCTION GetRecordSet(sql AS STRING) AS STRING
LOCAL sArray() AS STRING
slSelAry sql,sArray(),"Q9"
FUNCTION = JOIN$(sArray(),$CRLF)
END FUNCTION
#3
1) I had "Receive Emails and Alerts" for this forum, but can't find an email.
2) Forum Look and Layout "Turn notification on when you post or reply to a topic"
3) Account setttngs:  email address is current
4) Maybe something more?  Yes, found these under notifications. 

Notifications checked:
Receive forum newsletters, announcements and important notifications by email.
Follow topics I create and reply to
Receive message body in e-mails
How frequently to tell me immediately
Notify me of Replies and moderation

When a new topic is create in a board I follow, I normally want to know via
Receive alert and email checked

Posts
When one of my posts is quoted  receive alert and email
When a reply is made to my unapproved top receive alert and email

Personal Messages
If enable, notify me of personal messages from All members
When I receive a new personal message receive email
When I receive a reply to a personal message  receive email

Members
When other members add me as their buddy receive alert (can't check email)
When it's my birthday receive email











Looking again for an email and will recheck my settings.

Thanks, Paul.  8:53 AM CST Sunday July 31, 2022
#4
General Board / Paul Squires
July 30, 2022, 05:54:11 PM
Paul,
Do you get email notifications?
#5
Here is another test.  Did you receive an email notification on this post #6?
Still haven't heard back from Fredrick.
#6
Other 3 boards just appeared!
#7
142 posts in General board.  Rest are gone, here.
#8
Only general board for me.  Going through settings.

#9
Now there is only the general board.  No email alerts (for others.)
#10
Did you get this one?!
Please click the button on the  end of the reply line and toggle it to Receive Emails and Alerts.
There are probably more things to change and check that you email address is current.
I received a notification Receive Email Notifications and Alerts.  I think something changed for everyone.
#11
This is a test to see if anyone receives a notification by email of this post.
Something may have changed.

"Receive alerts" may have to be changed to "Receive Emails and Alerts" with each new subject?
The button is at the top on the end of the Reply line, click it and change to the last option.


#12
I got an email that you responded.  Did you get an email that I posted this?
#13
Please be sure RECEIVE EMAILS AND ALERTS is toggled on in each forum and your email address is current.
Instead of taking minutes to contact you it takes weeks or months.
#14
Fredrick,
Did you get this post?  Please be sure "RECEIVE EMAILS AND ALERTS" is toggled on at the end of the REPLY line.
#15
Did you get an email notification that I posted this response?
If not, please be sure RECEIVE EMAILS AND ALERTS is choosen on the end of the reply line.
There are several options

Yes, all options are "remote" since slConnect is needed.
The server can be on intranet or internet.
The data is unencrypted to and from the server.