Results 1 to 40 of 269

Thread: VB SQLite Library (COM-Wrapper)

Threaded View

  1. #11

    Thread Starter
    PowerPoster
    Join Date
    Jun 2012
    Posts
    2,728

    Re: VB SQLite Library (COM-Wrapper)

    sqlite3_bind_text16 now fixed to use directly StrPtr(Value).
    I don't know what triggered me to cache it in a variable and append a vbNullChar. Normally I don't do it when sending a string to an API.

    Quote Originally Posted by wqweto View Post
    Btw, in SQLiteCursor.SetParameterValue there is Case vbDouble but vbSingle is missing.
    That was done by intention to force strict data types. So storing a Date variable needs to be passed with CDbl(), for example. (or as string or julian date .. , depends how somebody handles it)
    Only for vbInteger/vbByte there is an exception, since a 0 is already an integer unless 0& is used.
    If you think otherwise please suggest. Thx
    Last edited by Krool; Aug 2nd, 2022 at 01:27 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width