Search results

Well, here's an interesting development. I tried getting the same product variant info from shopify using the API, and it returned 404 -- not found -- even though the ODBC driver pass-through query returned a value in 80 seconds. So then I tried getting product info, rather than product...

Yes, the Devart ODBC driver uses Shopify's API and translate that into tables for linking into Access or connecting through a pass-through query. ODBC drivers will interpret the command given to them and only pull the data that's needed. Unless there's a heterogeneous join. Then it'll pull the...

Nope. No difference. Using a different IP with my phone's hotspot the results were the same. I even created a new database and tried it there. Same. So it's not the IP. Of course, it could be the MAC address or something else. But doesn't seem to be the IP.

Yes, I considered that. Only thing is, the license is for only one computer. And the only other license is on the client's computer, and I don't want to bring him into this yet. But... you just gave me an idea. I could use my phone as a hotspot and connect through my phone with a different IP...

Yeah, I couldn't find anything through Google or ChatGPT.

I've also contacted the support team of the app. But, still, if my IP is blacklisted or graylisted, then Shopify would be the ones to know, not the 3rd party app, right?

Thanks, I'll do that. I did post a message in the Shopify help forum. I don't know if a staff member will reply. They don't seem to have a place to open a support ticket, only a place to chat with support (which I hate). So I'll see what happens. Interesting, the first time I ran the query, it...

I have. But I would prefer to use the odbc tables instead. There should be a reason why it's this slow. And I checked the Devart support forum and I didn't see a lot of posts about slowness. So there must be something going on, either with my machine or something I'm doing wrong. I have a hard...

I'm connecting to Shopify via the Devart ODBC driver and Microsoft Access. I'm finding some very long download times. For example, using a pass-through query in Microsoft Access, with my DSN name in the connection string, I am sending this statement to Shopify: Select Sku, InventoryQuantity...

The example I gave with "Table1" was just a simple mockup I did of how it might actually be used. But in the real world it would be used with a recordset that would be at the correct record. So, yes, a single record would be modified. That's the intent.

Yes, of course. I guess I just didn't think it through. I mean, I would never set an object to a variant datatype within a procedure. I would use an object variable. But somehow the "ByRef" threw me off, and I didn't see it the same as setting a variable. But it is, since the parameter is a...

I used variants to account for the possibility of Null values being passed. And not trying to be clever. Just trying to save keystrokes. Sorry you think my coding is sloppy.

@ebs17: Ouch! OK, never mind. Have a nice day!

That makes sense. I'm curious, though, what you think of the article that gasman shared, above. Unless I'm reading it wrong, it seems to say that fields are modifiable. What is your take on it?

Thanks! That certainly addresses the issue. The only is, that article lists fields as modifiable, and only lists "Read-only variables, fields, and properties" as non-modifiable. The field I passed was definitely modifiable. ??

You had changed the function so that it didn't increase the value of the first parameter, but only added them together as a return value. The original function simply had: varBaseAmt = Nz(varBaseAmt, 0) + Nz(varNewAmt, 0)

Yes, it works if you return a value from the function. But then that defeats the purpose of using the function in the first place, since you're still repeating the value to be added to twice.

Same results.

Yes, that's what I ended up doing. And, yes, it works if you do it the standard way. And, no, error notification's in place. In fact, both functions have error handlers in place. I just removed them for posting here.

So, I have a function that's meant to emulate += in Access to add a value to another value without having to repeat the first value. It's a simple function: Public Function pe(ByRef varBaseAmt As Variant, varNewAmt As Variant) varBaseAmt = Nz(varBaseAmt, 0) + Nz(varNewAmt, 0) End Function...