Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Japetus
Mors et Tributum The DNA Conglomerate
0
|
Posted - 2017.01.11 04:08:23 -
[1] - Quote
I'm making an excel spreadsheet, in it I am referencing some of the SDE files... however I recently ran into a problem... maybe someone here can figure out what Im doing wrong
Basically Im querying the SDE File with a ADODB connection where I take the result of a query and put it into an array with getrows() in vba
Now for the problem... if I do this: "SELECT TypeID, TypeName, GroupIDFrom invTypes.csv WHERE MarketGroupID = '" & Data & "'"
I get all the rows in my getrows but only for the TypeID, and TypeName
if I do: SELECT TypeID, TypeName I get results for TypeID
If I do SELECT TypeID I get the following error: Run-time Error 1004 application defined or object defined error
Any idea at all whats going on here? Obviously I can just add an extra field after what I need which I will if I cant figure this out.... but figure if I can figure it out Id much rather get it right.
Thanks |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6361
|
Posted - 2017.01.11 13:25:25 -
[2] - Quote
I'd highly recommend having it hooked up to a proper database, rather than going from the CSVs.
SQLite is certainly an option.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Japetus
Mors et Tributum The DNA Conglomerate
0
|
Posted - 2017.01.12 01:54:32 -
[3] - Quote
lol you're killin me steve, you keep gettin me to take steps further from excel and more into actual app development :p
If I finally take the last step you have any issues with php? its what I know the most in, which isn't saying a lot lol, well with the exception of vba ofc since... well... excel and all |
Japetus
Mors et Tributum The DNA Conglomerate
0
|
Posted - 2017.01.12 21:50:22 -
[4] - Quote
so with SQL which I only have a basic knowledge of, lets take PI for instance... If I want to take a P4, and list all its P3 inputs and the quantity needed, then go beyond and take all the P3s I just found and convert it to P2 imputs so that I would have the exact amounts of P2 that I would need for that P4 I would have to generate a table for pretty much everything wouldnt I? I had been thinking of just making a variable array in excel and just manipulate that variable....
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6370
|
Posted - 2017.01.12 21:54:15 -
[5] - Quote
Eh, php works :) It's what I do most of my frontend work in. (in part because I like the feedback loop, in part because it's what I've used in the past).
For non-interactive scripts, I tend to use Python these days. But it's all doable.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |