dcsimg

Search:

Type: Posts; User: samer22

Page 1 of 13 1 2 3 4

Search: Search took 0.22 seconds.

  1. Re: Import table to SQLite database

    thank you very much
    it worked
  2. Re: Import table to SQLite database

    thank you very much
    it worked
  3. Re: Import table to SQLite database

    When you say attach; do you mean place in the same path?
    Is the copying query the same as we used to do with mdb database?
    thank you
  4. [RESOLVED] Import table to SQLite database

    Hello everyone
    Im using SQLite and Vbrichclient5
    I have SQLite database (PData.db) and another database named GData.db.
    I want to import a table (Tbl_Pic) from GData.db into PData.db.
    Is that...
  5. Replies
    21
    Views
    831

    Re: Convert .Mdb to sqlite3

    Olaf
    I'm so grateful to you
    I've been playing with some sqlite tools, and the name of the field has slightly been changed.
    the field name ( Date_End) has been quoted and becomes 'Date_End '
    I...
  6. Replies
    21
    Views
    831

    Re: Convert .Mdb to sqlite3

    Olaf
    I'm so grateful to you
    I've been playing with some sqlite tools, and the name of he field has slightly been changed.
    the field name ( Date_End) had been quoted and becomes 'Date_End '
    I...
  7. Replies
    21
    Views
    831

    Re: Convert .Mdb to sqlite3

    Thank you Schmidt for your interest and help
    However I'm still having trouble o convrte my long format date
    This is what I did


    Set cnn = New_c.Connection(App.Path & "\ProbData.db")...
  8. Replies
    21
    Views
    831

    Re: Convert .Mdb to sqlite3

    xiaoyao
    using the tools that qvb6 has provided you can export to csv or import from csv
  9. Replies
    21
    Views
    831

    Re: Convert .Mdb to sqlite3

    qvb6
    thank you for the tools you provided
    I was able to add a foreign key but I couldn't figure out how to modify dates from long to short format
    Can anyone tell me howto do that with code....
  10. Replies
    21
    Views
    831

    Convert .Mdb to sqlite3

    Hello experts
    I used olaf's Demo "Nwind-Demo" to convert my acceess file to sqlite3
    Everything was alright except two things.
    1) The conversion doesn't take into account the relation between...
  11. Replies
    12
    Views
    574

    Re: Question about Olaf's AppServer-Dll

    thank you again sir for your generosity
    I'm struggling hard to understand the techniques
    I'll come back when I need to.
  12. Replies
    12
    Views
    574

    Re: Question about Olaf's AppServer-Dll

    I'm so grateful to you jpbro
    you're a great gentelman
    million thanks
    I need some time to read every word and play with the demo
  13. Replies
    12
    Views
    574

    Re: Question about Olaf's AppServer-Dll

    both
  14. Replies
    12
    Views
    574

    Re: Question about Olaf's AppServer-Dll

    jpbro
    thanks a lot
    But as a newbie this is far away from my capacities
    Anyway thank you very much
  15. Replies
    12
    Views
    574

    Question about Olaf's AppServer-Dll

    Hello Olaf
    Hello everyone
    I'm using Olaf's AppServer-Dll.
    I want to know if it is possible to send files to ServerApp\RpcDlls folder.
    thank you
  16. Re: Updating database through Krool's VBFlexGrid

    please am I doing right?
  17. Re: Updating database through Krool's VBFlexGrid

    Thanks Olaf
    I felt happy when I read this




    I have studied your extraordinary Demo but I think it is not complying with my case.
  18. Re: Updating database through Krool's VBFlexGrid

    It seems the way I wish to do has no way !!

    Sad Day ::
  19. Re: Updating database through Krool's VBFlexGrid

    Thank you Olaf
    Your demo is extraordinary
    unfortunately I was unable to adapt it o my needs.
    This my project based on your sample demo


    Thank you for the help you are providing
  20. Updating database through Krool's VBFlexGrid

    Hello VbForums
    I'm using Sqlite3 and VbRichclient 5. In one of my forms, I am saving data by using Krool's VBFlexGrid. This is my code:

    StrSql = "Select * from tblNotes Where ID =?"
    ...
  21. Re: Saving listview items is very slow

    Thank you very much
    Solved
  22. [RESOLVED] Saving listview items is very slow

    Hello Vbforums Community
    I'm saving about 200 Listview items in database by means of RS Add or even insert method but the operation is very slow and looks sluggish and causes the system to freeze...
  23. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    sorry there is duplication of my post I did not how this happened
    thank you sir million times
  24. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    jpbro
    The users who are using my application and who already have data in their db will lose their data.
    since recompilation of the SQLiteServer DLL is necessary
    thank you
  25. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    jpbro
    The users who are using my application and who already have data in their db will lose their data.
    since recompilation of the SQLiteServer DLL is necessary
    thank you
  26. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    I'm deeply sorry
    This is the point I was missing
  27. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    Incredible!!!
    I did exactly as jpbro told me but I'm faced with the message Cannot compile .. file is not a database

    172219

    would you please send me a working Demo?
  28. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    jpbro
    I'm so grateful to you for the clarifications you brought
    I understand the connection method.
    However I spent long hours trying to unlock the database but in vain.
    I'm getting a message...
  29. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    thank you sir
    but how to make use of the function in this connecting string?

    DBClient.Connect "127.0.0.1", "Test.db"
  30. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    thanks for answering

    yes that's it
  31. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    jpbro
    Please help me
    This was my connection string before introducing the SQLite Server Mode.

    Set Cnn = New_c.Connection(DBPath)
    Cnn.ReKey "Med12345"
    Cnn.OpenDB DBPath, "123456"
    "DBPath" is...
  32. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    an empty string passed to GetIP
  33. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    it worked
    thank you
  34. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    it worked
    thank you
  35. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    jpbro
    THANKS FOR REPLYING

    this is a static ip

    In the Demo submited by Olaf there is a local IP in both the server and the client form load event.

    yes it has
  36. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    Olaf
    Thanks to your advice I was able to solve the problem on XP
    I downloaded ad registered tha last version of VbrichClient5 on xp and W7.
    On the Local IP, it worked fine. But when I conected...
  37. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    Schmidt
    thank you again

    even on xp machine the RC5-Dlls registered and the MSHFlexGrid are registered.
    I can launch other projects using RC5 without issue.


    Both of them throw the error....
  38. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    thanks sir
  39. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    Schmidt
    Thanks for the clarifications
    what about the Windows XP issue please?
  40. Replies
    57
    Views
    1,427

    Re: Question on refreshing data

    Thank you very much sir
    I tested the Demo on windows7 and it worked very well.
    however when I testedit on a Windows XP machine i hrowsan error
    "ActiveX component can't create object"
    What...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width