Missing Operand - Xtreme Visual Basic Talk

11-07-2003, 08:48 AM

Phluxed

Centurion

Join Date: Sep 2003

Posts: 124

Missing Operand

I have the following code

Code:

OpenFox
With FoxR
    .ActiveConnection = FoxC
    .Source = "Select * From TABLES Where NUMBER = " & tablenum
    .CursorType = adOpenStatic
    .LockType = adLockOptimistic
    .CursorLocation = adUseClient
    .Open
    If Not .BOF And Not .EOF Then
        .Fields("TIMETYPE").Value = timetype
        .Fields("NAME").Value = name1
        .Fields("RUNTIME").Value = time1 & ":" & time2
        .Update
    End If
    .Close
End With

and on the line .Open I get the error Missing Operand.

__________________
In THEORY communism works... In THEORY Mountain Dew tastes good...

11-07-2003, 09:42 AM

wildbeliefs wildbeliefs is offline

Freshman

Join Date: Oct 2003

Posts: 42

I'm assuming that FoxC is properly defined, right?

11-07-2003, 09:44 AM

Phluxed

Centurion

Join Date: Sep 2003

Posts: 124

Quote:
Originally Posted by wildbeliefs
I'm assuming that FoxC is properly defined, right?

I believe so. I mean, the exact code works in another place.

__________________
In THEORY communism works... In THEORY Mountain Dew tastes good...

11-07-2003, 10:03 AM

wildbeliefs wildbeliefs is offline

Freshman

Join Date: Oct 2003

Posts: 42

[QUOTEPOST='Phluxed']

Code:

OpenFox

    .Source = "Select * From TABLES Where NUMBER = " & tablenum

you're missing the & ";" at the end of your sql statement. I don't remember if you also need single quotations around tablenum or not...

11-07-2003, 10:09 AM

Phluxed

Centurion

Join Date: Sep 2003

Posts: 124

Merci Buckets. Thanks for the extra pair of eyes. Figured it out.

__________________
In THEORY communism works... In THEORY Mountain Dew tastes good...

11-07-2003, 10:14 AM

reboot

Keeper of foo

Retired Moderator
* Guru *

Join Date: Nov 2001

Location: Graceland

Posts: 15,612

";" at the end of an sql statement is unnecesary. That couldn't have been the problem.

__________________
~ Quod non mortiferum, fortiorem me facit ~

Avatar by lebb

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
compare excel sheets / find missing records	screw	Excel	2	07-31-2003 06:05 AM
Missing Reference in VB	Niren	General	3	06-27-2003 04:11 AM
Problem with Direct Input and Direct Sound	Waxycat	Miscellaneous Languages	15	06-06-2003 11:03 AM
Yoderic's Battle Arena -- Come And Play!!	JDYoder	Game Programming	4	12-11-2001 09:59 AM