Search:

Type: Posts; User: newbie2

Page 1 of 13 1 2 3 4

Search: Search took 0.14 seconds.

  1. Replies
    7
    Views
    375

    Re: Need help with flexgrid

    Sam
    I'm so grateful to you
    Million thanks
    solved
  2. Replies
    7
    Views
    375

    Re: Need help with flexgrid

    No
    each item is appearing in its own row
  3. Replies
    7
    Views
    375

    Re: Need help with flexgrid

    thanks
    I have corrected my mistake
    I need to get the two items (aaa and bbb) in one sigle row instead of two seperate rows.
  4. Replies
    7
    Views
    375

    [RESOLVED] Need help with flexgrid

    Hello vbforums
    I have a table like this
    ID---------- Item
    1 ---------- aaa
    1-----------bbb

    Select* from Tbl where ID=1 group BY ID, Item"
    Do While Not Rs.EOF
    Text1.Text = Text1.Text & " " &...
  5. Replies
    35
    Views
    1,437

    Re: [RESOLVED] Need help with a querry

    I have modified Sam's updating codes.
    My updating is based on the auto increment field not on the item_id.

    Everything is allright now

    thank you all of you
  6. Replies
    35
    Views
    1,437

    Re: [RESOLVED] Need help with a querry

    of course I'm quite aware of all that.
    Thank you
  7. Replies
    35
    Views
    1,437

    Re: [RESOLVED] Need help with a querry

    SamOscarBrown
    You are a great gentelmen
    I was making a slight mistake in my update codes that's why it did not work properly.
    Million thanks sir.
    solved
  8. Replies
    35
    Views
    1,437

    Re: [RESOLVED] Need help with a querry

    SamOscarBrown
    Thank you again
    Unfortunately I'm having big trouble to convert your codes to SQlite
    I failed to update the appropriate rows.
    I think it has to do with the cursor location.
    ...
  9. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    SamOscarBrown
    All the words of thanks do not fulfill what you really deserve.
    Million thanks
    that's exactly what I was looking for .
    May God Bless you
  10. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    This is what I have been trying to do for a week but no success.


    StrSql = "Select max(Aut), remain, payment, Total_payment from Trans where paid= 0 And id = 1 Group by Item_Id"
    Set Rs =...
  11. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    the new payment is distributed on the 1st item, 2nd item, 3rd item, 4 th item ..... until the new payment runs out.
    The new payment may expire with the 1st item if the debt related to the first item...
  12. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    SamOscarBrown
    I put your message into google translate and if I understand you well, what you think is not applicable as real scenario, I can assure you that it is very possible and very common...
  13. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    ChrisE
    thank you again and again
    I examined your sample and I figured out that it is dealing with each item seperately.
    What I'mlooking for is making a payment that deals with the three items in...
  14. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    Good News.

    In fact my current program is dealing with each item separately. It looks like the screenshot submitted by Mr SamOscarBrown.
    ...
  15. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    SamOscarBrown
    thank you for the screenshot

    what if the customer (Sam Brown) made a payment of of 100 without specifying the item.
    Is it possible for the program to distribute this sum on the...
  16. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    ChrisE
    I thank you very much
    I 've just come home and it's very late now.
    Tomorrow I'll test your codes and let you know
    thanks a lot
  17. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    ChrisE thanks a lot
    but how can I add my new payment ?
    PLease have a look on post 7.
  18. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    that's exactly sir
    thank you for correcting my calculations
    and thank you for putting the scenario in native english

    yes you're right sir

    I need a code to do that.
    thank you
  19. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    Now I changed the fields names to become more meaningful
    180960
    180961
    In this scenario a customer whose ID is 1 has bought four items.
    Item1 whose price is 100. the customers made 3 payments...
  20. Replies
    35
    Views
    1,437

    Re: Need help with a querry

    English is not my native language
    Deposit = payment


    I want to distribute the '80' on the three items.
    Have you got any other simple approach?
    Thank you
  21. Replies
    35
    Views
    1,437

    [RESOLVED] Need help with a querry

    Hello Vbforums
    First I have to thank szlamany, Arnoutdv and Zvoni who did their best to help me in DataBase Development forum.
    Unfortunately I was unable to solve my issue.
    Sincerely the querries...
  22. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    Hello everyone
    I took another approach because I found it easy to grasp.

    StrSql = "Select max(Aut), remain, deposit, Total_deposit from Trans where acquit = 0 And id = 1 Group by Item_Id"...
  23. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    Thak you gentelmen . I'm so grateful to you all
    I took profit of all your notes and updated Sqlite and RC5
    And now I'm on the way to find my hapiness.
    except for some worries.
    This is the...
  24. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    I followed your link and I tested the sample they provide but I 'm always having the same mistake either in db browser or on the form.

    Cnn.Execute "CREATE TABLE t0(x INTEGER PRIMARY KEY, y TEXT);"...
  25. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    I was using an old version 3.22 but now I'm using the last version 3.35.3
    However my trouble still continue.
    When I started googling about my error, I found many people were complaining about the...
  26. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    After some googling I think SQlite does not support ROW_NUMBER() OVER PARTITION
    but I think there is an alternative.
    However this seems very complicated regarding my modest knowledge.
  27. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    I suspect the error resides somewhere here in this piece:

    LEFT JOIN
    (SELECT
    Aut,
    ID,
    remain,
    Acquit,
    ROW_NUMBER() OVER(PARTITION BY item_id...
  28. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    Same error all the times even with single lines

    This is my code for table creating

    Cnn.Execute "Create Table Trans (Aut int, ID int, Item_id int, price int, deposit int, Total_deposit int,...
  29. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    still no succes
  30. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    I created a new table with the same fields based on szlamany demo.
    thanks
  31. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    Thank you sir
    I run the query in DB-Browser and it is throwing the same error
    This is exactly the error:


    near "(": syntax error: SELECT DISTINCT
    T1.aut,
    t2.remain
    From
    trans As T1
  32. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    Thank you very much Zvoni
    I have been struggling to make the first query into practice but I'm facing with this error.
    I made all possible change but still with no luck.

    180848

    180849

    ...
  33. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    very glad to hear that
    thank you very much
  34. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    I'm so so sorry for bothering you sir
    you are so helpful and so kind
    I spent more than 4 hours trying to adapt the codes to sqlite but syntax seems different from MS SQL.
    I must wait for someone...
  35. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    I'm using SQlite and RC5 same as ADO


    As far as I know views are virtual tables, but I have not enough experience with that.

    Sub queries yes but nested queries no idea.
    thanks
  36. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    Thank you for the interest sir
    I have an auto increment column

    180832
  37. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    szlamany
    I am so grateful to you for your interest and your time
    However what you are suggesting looks out of my reach.

    Arnoutdv
    I thank you very much for your help
    Is there a simpler approach...
  38. Replies
    40
    Views
    1,628

    Re: Very complicated but perhaps possible!

    Thank you sir

    "Select * from tbl where acquit = '0' And id = '1'Group by Item_Id"
    Rs.MoveLast
    Rs!deposit = val(txt_payment.Text) - Rs! Remainder
    Rs! acquit = 1
    Now Item 1 is acquitted, I...
  39. Replies
    40
    Views
    1,628

    Very complicated but perhaps possible!

    hello vbforums
    I have a very complicated query I'm asking experts if it is possible to run this query.
    This is my table

    180822
    180823

    As shown in table the record has a debt of 60 + 10 +...
  40. Replies
    8
    Views
    481

    Re: sum a field with group by

    it worked thank you very much
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width