Script help

[alphatech]

I'm trying to write a script that writes to a Mysql database. I have it done but I have several minor issues.
I have a very long insert statement right now on one line, see below. How do I spit the statement in few extra lines?

[sparkman]

Use hs.devicevalueEx(xxxx) instead.

[alphatech]

Thanks sparkman, how do I spit a long insert statement in multiple lines. Right now is diffould to read it. I tried _ but does not work.

[sparkman]

Can't see your script anymore, so don't know why not. One option may be to use more variables, define those before your insert statement and then use the variables in the insert statement, but without seeing it, hard to know for sure.

[alphatech]

sorry, here it is. I'm starting to replace with these instead but still a long query.
Dim Dev_EnergyAddedbyLastCharge as Double
Dev_EnergyAddedbyLastCharge = hs.devicevalue(2537)

myCommand.CommandText = "Insert into teslacharge (chargestatus, energyaddedlastcharge, energycostlastcharge, energycostkwh, odometer, batterylevel, batteryrangeestimated, batteryrangeideal, batteryrange, milesaddedlastchargeestimated, milesaddedlastchargeideal, insideTemperature, outsideTemperature, latitude, longitude, location ) VALUES ('" & hs.devicevalue(2536) & "','" & Dev_EnergyAddedbyLastCharge & "','" & hs.devicevalue(2555) & "','" & hs.devicevalue(2554) & "','" & hs.devicevalue(2497) & "','" & hs.devicevalue(2498) & "','" & hs.devicevalue(2499) & "','" & hs.devicevalue(2500) & "','" & hs.devicevalue(2501) & "','" & hs.devicevalue(2539) & "','" & hs.devicevalue(2538) & "','" & hs.devicevalue(2518) & "','" & hs.devicevalue(2519) & "','" & hs.devicevalue(2547) & "','" & hs.devicevalue(2548) & "','" & hs.devicevalue(2549) & "')"

[langenet]

You could shorten it up by just specifying the values and not the attributes as long as they align to the same order...

[alphatech]

It makes sense, i will do it. I'm surprised that VB does not have something that let you go to the next line. I saw in a script that they use this symbol "_" but does not work when I do it

[Guest]

It makes sense, i will do it. I'm surprised that VB does not have something that let you go to the next line. I saw in a script that they use this symbol "_" but does not work when I do it

When you use the _ character to indicate the next source line, the _ must be separated by a space, and cannot be inside a quoted string.

buff = "this is a string " + _
            "that is very long."

[sparkman]

The issue is that the whole thing is one string, so _ won't work. You could do something like this:

Dim myCommandString as String = ""
myCommandString = "Insert into teslacharge (chargestatus, energyaddedlastcharge, energycostlastcharge, energycostkwh,"
myCommandString = myCommandString & "odometer, batterylevel, batteryrangeestimated, batteryrangeideal, batteryrange,"
myCommandString = myCommandString & "...
etc.


myCommand.CommandText = myCommandString

[alphatech]

Thank you, you have been of a big help.
On this last part of the insert statement (Dev_Location) is a string. & Dev_Longitude & "','" & Dev_Location & "')" I do not know how to put the "" around it instead of a single quote. The Dev_location is a device string.

[sparkman]

In that case you eliminate the single quotes around those.

& Dev_Longitude & "," & Dev_Location & ")"

[sparkman]

Please use the script tags in the forum, as the forum can insert spaces into regular text, but it won't do that with script tags surround the text. It's best to delete your previous post, create a new post, insert the script tags and then paste your code in between. The script tags are available in the advanced editing mode, so you may need to click on the "A" button when creating the post. The script tags are the button with the # on it.

[alphatech]

Sorry to give so much trouble, I tried it but does not work, I'm sure because I added another field after it.

myCommand.CommandText = "Insert into teslacharge (chargestatus, energyaddedlastcharge, energycostlastcharge, energycostkwh, odometer, batterylevel, batteryrangeestimated, batteryrangeideal, batteryrange, milesaddedlastchargeestimated, milesaddedlastchargeideal, insideTemperature, outsideTemperature, latitude, longitude, location, ymd ) VALUES ('" & Dev_ChargeStatus & "','" & Dev_EnergyAddedbyLastCharge & "','" & Dev_EnergyCostLastCharge & "','" & Dev_EnergyCostKwh & "','" & Dev_Odometer & "','" & Dev_BatteryLevel & "','" & Dev_BatteryRangeEstimated & "','" & Dev_BatteryRangeIdeal & "','" & Dev_BatteryRange & "','" & Dev_MilesAddedLastChargeEstimated & "','" & Dev_MilesAddedLastChargeIdeal & "','" & Dev_InsideTemperature & "','" & Dev_OutsideTemperature & "','" & Dev_Latitude & "','" & Dev_Longitude & "," & Dev_Location & "','" & strfulldate & "')"

[sparkman]

Sorry to give so much trouble, I tried it but does not work, I'm sure because I added another field after it.

Can you post the whole script? Does MySql require the single quotations around the values you are inserting?

[alphatech]

Please see attached. I believe on the string it needs this quote " as an example would be "home"