Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Crazy vb6.0 problem im clueless help!!!!

  1. #1
    Join Date
    Dec 2004
    Posts
    139
    Rep Power
    0

    Exclamation Crazy vb6.0 problem im clueless help!!!!

    This is a question for VB 6.0 database programmers if there are any of you on here. WHAT IN THE WORLD IS A SYNTAX ERROR IN FROM CLAUSE AND HOW DO I FIX IT. Ive improved wickedly in the space of a few hours somebody please help me!!!

    Im praying that one of you on here can help me and even if you cant help me point me to an external source please !!!!!!!!!!!!!

  2. #2
    Join Date
    Aug 2002
    Posts
    6,223
    Rep Power
    0

    Default

    Syntax error in FROM clause indicates there is an error in your database query, most likely after a FROM statement.
    .
    PC - Ubuntu 15.04 64bit Desktop
    HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home

    "So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"


    RIP Ramesh ...

  3. #3
    Join Date
    Dec 2004
    Posts
    139
    Rep Power
    0

    Default

    can you tell me where i can find that FROM statement i have no clue where that is or can you at least give me an idea?

  4. #4
    Join Date
    Sep 2004
    Posts
    1,905
    Rep Power
    21

    Default

    Give us an idea of the code you have running, a snippet. Are you using stored proceedures? Anyway trace the program to the place where the vb code excecutes a sqlcommand like a select command and then check the details of the command or query. If it indicates that the command is in a different file like a stored proceedure, then post the contents of that file.
    Let's act on what we agree on now, and argue later on what we don't.
    Black men leave Barbeque alone if Barbeque don't trouble you

  5. #5
    Join Date
    Dec 2004
    Posts
    139
    Rep Power
    0

    Exclamation

    fixed it apparantly "Date" is a reserved sql word or something like that. All i did was change the field name from "Date" to "Current Date" inside the ingredient table in my current database..
    Last edited by caesar2004; Aug 26, 2005 at 02:20 AM.

  6. #6
    Join Date
    Dec 2004
    Posts
    139
    Rep Power
    0

    Default

    x = 1
    c = 0
    Dim a(10) As Integer
    For x = 0 To x
    List2.AddItem Text1.Text, a(c)
    x = x + 1
    c = c + 1
    Next

    anyone got any improvements to this little snippet of code?

  7. #7
    Join Date
    Dec 2004
    Posts
    139
    Rep Power
    0

    Default

    im having another problem im adding data to a list box right and im trying to do some calculations on it.

    if listbox.text = "water" then
    text7.text= 10*20
    end if

    This little snippet of code apparantly does nothing at all!!!

  8. #8
    Join Date
    Aug 2002
    Posts
    6,223
    Rep Power
    0

    Default

    Quote Originally Posted by caesar2004
    im having another problem im adding data to a list box right and im trying to do some calculations on it.

    if listbox.text = "water" then
    text7.text= 10*20
    end if

    This little snippet of code apparantly does nothing at all!!!
    Try adding an"ELSE" statement in side that code.
    .
    PC - Ubuntu 15.04 64bit Desktop
    HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home

    "So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"


    RIP Ramesh ...

  9. #9
    Join Date
    Dec 2004
    Posts
    139
    Rep Power
    0

    Exclamation

    x = 1
    c = 0
    Dim a(10) As Integer
    For x = 0 To x
    List2.RemoveItem Text1.Text, a(c)
    x = x + 1
    c = c + 1
    Next

    i get the error message wrong number of arguments or invalid property assignment
    i dont see anything wrong with that code

    I got it to work apparantly with a list box you have to like click the actual item before you can run any form of operation on it
    Last edited by caesar2004; Aug 26, 2005 at 09:02 AM.

  10. #10
    Join Date
    Dec 2004
    Posts
    139
    Rep Power
    0

    Exclamation

    fixed it all i had to do was remove text1.text. even though this works i want a better way to delete items. i want to click on the specific item and press remove and it removes that item. any ideas would i have to use split() or mid() or something of the other?

Posting Permissions

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