[shanondink]

Seems my ITEMS and TRANSACTIONS tables are empty. They are there, they just don’t contain any records when I query them

Neither Excel, WinSQL, nor my custom built app show any records in either table.

All the others I’m looking atCASE_STAGE_CHANGES
SUPPORT_INCIDENTS
ENTITY
TRANSACTION_LINES

seem fine.

And the crazy thing is that I join TRANSACTIONS on my query for TRANSACTION_LINES and that works fine.

Code:
SELECT
TRANSACTION_LINES.*
FROM TRANSACTION_LINES
INNER JOIN TRANSACTIONS ON TRANSACTION_LINES.TRANSACTION_ID = TRANSACTIONS.TRANSACTION_ID
WHERE
(((TRANSACTIONS.TRANSACTION_ID) >98500) AND
((TRANSACTIONS.TRANSACTION_TYPE)=’Invoice’ Or
(TRANSACTIONS.TRANSACTION_TYPE)=’Sales Order’ Or
(TRANSACTIONS.TRANSACTION_TYPE)=’Item Fulfillment’))
ORDER BY TRANSACTION_LINES.TRANSACTION_ID, TRANSACTION_LINES.TRANSACTION_LINE_ID, TRANSACTION_LINES.TRANSACTION_ORDER
Is anybody else seeing this?
This is a cached copy. Click here to see the original post.

[shanondink]

RE: ITEMS and TRANSACTIONS tables seem empty

Is nobody else seeing this?

With Access, I can view data in these tables only if I “Link” to them. But if I try to “Import” the table or run a “Make Table” query on that Link to create a new table with the data, it doesn’t work.

In Excel, WinSQL, or my custom VB.NET app, I get the description of the table, but no data. This is from 2 PCs.

I’m seeing this now on:

ITEMS

ENTITY

TRANSACTIONS

SUPPORT_INCIDENTS

CUSTOMERS

SUPPORT_REPS

But CASE_STAGE_CHANGES and TRANSACTION_LINES work fine.

I can’t see how this can be my fault when 2 tables work but the rest don’t.

I have a case # 473101 open but probably won’t get any love on it for a week or two

[elena]

RE: ITEMS and TRANSACTIONS tables seem empty

Do you have any custom item fields or custom entity fields with Type = Rich Text or Long Text set up in you account?

[shanondink]

RE: ITEMS and TRANSACTIONS tables seem empty

Hi Elena,

For some reason it just started working when I tried it at ~4:30 PM CST today. I did nothing on my side.

Originally posted by elena

Do you have any custom item fields or custom entity fields with Type = Rich Text or Long Text set up in you account?

We have a several custom fields of type Free-Form Text, Date, and Long Text on our customer record but they were there before it broke.

Do you know what the fix was? Or was anything fixed?

Thanks if you did something to fix it

Shanon

[Author]

Posts