• Welcome, Guest. Please login.
 
July 23, 2021, 08:07:35 PM

News:

Welcome to the SQLitening support forums!


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.

Topics - Marc Van Cauwenberghe

1
Hi,

has anyone tried to add full text search to his/her database?

Regards,
Marc
2
Hello all,

Seem to be getting the above mentioned error, but I do not know why. I have pinpointed it but do not know what to do with it.
I have 2 tabels:

<'KlantAfspraken' is duch for 'CustomerApointments'>
CREATE TABLE [KlantAfspraken] (
  [Id] INTEGER PRIMARY KEY,
  [KlantId] INTEGER,
  [DateTime] LARGEINT,
  [Onderwerp] CHAR(512),
  [AfspraakGemaaktOp] CHAR(12),
  [AfspraakVia] CHAR(1),
  [Uitkomst] CHAR(1),
  [UitkomstNota] CHAR(255),
  [Id2] INTEGER);

<'Klant' is 'Customer'>
CREATE TABLE [Klant] (
  [Id] INTEGER PRIMARY KEY,
  [Naam] CHAR(30),
  [Straat] CHAR(30),
  [Postnummer] CHAR(4),
  [Woonplaats] CHAR(15),
  [Telefoon] CHAR(20),
  [Fax] CHAR(20),
  [Telefoon2] CHAR(20),
  [GSM] CHAR(20),
  [Email] CHAR(40),
  [BTWNr] CHAR(20),
  [Referentie] CHAR(10),
  [Soort] CHAR(3));

The following query gives the error:
sSQL = " SELECT [Klant].[Id], [Klant].[Naam], [Klant].[Straat], [Klant].[Postnummer], " & _
          "   [Klant].[Woonplaats], [Klant].[Telefoon], [Klant].[Fax], " & _
          "   [KlantAfspraken].[Id], [KlantAfspraken].[KlantId], " & _
          "   [KlantAfspraken].[AfspraakGemaaktOp], [KlantAfspraken].[AfspraakVia], " & _
          "   [KlantAfspraken].[Uitkomst], [KlantAfspraken].[UitkomstNota], " & _
          "   [Klant].[Telefoon2], [Klant].[GSM] " & _         
          " FROM [Klant] INNER JOIN " & _
          "   [KlantAfspraken] On [KlantAfspraken].[KlantId] = [Klant].[Id] " & _
          " WHERE ([KlantAfspraken].[DateTime] >= 20120128000000 And " & _
          "   [KlantAfspraken].[DateTime] < 20120129000000) "       
   lRC = slSelAry (sSQL , g_aKlantAfspraak())


This query will run in SQLite Expert Professional!!!
When I remove [KlantAfspraken].[Id] from the query the code will run.
When I rename [KlantAfspraken].[Id] to [KlantAfspraken].[Id2] and rename the field in the table it runs in code.
Is there a restriction on using 2 identical fieldnames in a query even if the table names are included?

Thanks for any help.
Marc
3
Hello,

Got a problem with setting up a client-server program I made.
I works great at home, but I can't get it to work at the customer.
I get
"... Unexpected message..."
"-16 Can not Connect"
"Statement = Connect -- Server=10.0.0.189 Port = 51234"

I can ping to the 'server' pc
I have a shared folder on the 'server' pc where I start the client program.

Can anyone tell me how to start to figuring oput what is wrong?

Marc
4
Hallo,

SQLitening has a fast and easy way to get a recordset into an array:
---> slSelAry
Egrid32 has an easy way to get an array into a grid: 
---> SendMessage Hgrid, %EG_INTERNALSELECTUD, 1, 100
---> SendMessage Hgrid, %EG_LOADARRAY, VARPTR(MyArrayToLoad(1)), 50

Unfortunately they differ in there syntax
slSelAry produces an (real) array
%EG_LOADARRAy needs an one-dimentional array where all columns are seperated by $TAB

Is there any way we can mary them?
Putting it another way what is the best way to get a recordset into an egrid?

Marc



5
Yes, I know. I'am stupid :-[ :-[ :'( :'(

I have decided to convert from Paul's SQLite server to Fred and Paul's SQLItening and I can't get it to work.

Here is what I did.

Copied all files from latest version to folder om remote computer (lh00)
Made folder called Data and put sample.db3 in
Changed the cfg file
   -> host=lh00
Changed ExampleA.bas
   ->  slConnect "lh00"
   ->  slOpen "Data\sample.db3"


compile and run and I get error 14 unable to open database file


Any suggestions?

Marc


6
Hi,

I recently ran into some problems using access and SQL Tools (NOT THAT IS WAS SQLTOOLS fault). It is not solved yet and it has got me in some serious trouble. The use of my program needed administrator rights >:(!!!

OK, sorry about that.  My question.
Will the use of SQLite solve my problems. I mean, does it need the registry, has it got other dependencies, etc, etc, etc...?

Marc