Table Not found

Magno

Hi,

i want to get data out of a table ("Customer Different Addresses")
so i set IT=a-z,0-9,A-Z,_

with fields i could just do field_name instead of "Field Name"
but i cannot get to this table either with "Customer Different Addresses" or Customer_Different_Addresses

Does anyone know how i could get to that table?

Renaming isn't an option, it is an official Navision add-on made by our firm.

Thx in advance


[EDIT]
Forgot to say i try to contact the data from asp through an ADODB.CONNECTION

sgg

if you know that Table Number, have you tried using a Variable ?

e.g
Name CustDiffAddrRec
DataType Record
Subtype 123456


Then reference it using the Variable Name.
It could be something wrong in the Name you are Calling.

if it's a Report, Used the Table number for the DataItem

Magno

where do you have to create that var?

and also, if he wouldn't recognise the table it would just say Table does not exist.

Already tested with another not existing table...


I forgot to say in the first post i use ASP => see edit in first post also

sgg

Freightliner wrote:

where do you have to create that var?

and also, if he wouldn't recognise the table it would just say Table does not exist.

Already tested with another not existing table...


I forgot to say in the first post i use ASP => see edit in first post also

I thought it is in Navision.
I have not experienced the Problem in ASP

RobertMo

If you are you using SQL server then all tables that have property DataPerCompany=Yes (Default) can be found as:
<CompanyName>$<TableName>
like:
"CRONUS International$Cust_ Ledger Entry"
Rememer that some chars like ./\ are changed to underscore (_)

Just check with SQL Enterprise manager...

Magno

it is not an SQL database, it is a native db...

The problem isn't also in navision, it is when ASP wants to get the table...

Mehdi.Chahed

Hi,

It's really strange :?:
I've never used Navision DB in such a way but I've already worked with ASP.
You are connected to a Navision native db. I guess you are using C/ODBC?
In any case, if your C/ODBC connexion is well built & runnig, you should be able to create any kind of querry using the wizard (hope you are using a Microsoft enviroment).
So, 1st, check if the Navision ODBS Driver is installed on your Data server sysem (look for C/ODBC). Then, verify your connexion. Fianally, try the wizard.

Hope it helps.

Magno

found the solution:

you can't assign an alias to a table like "select * from Customer c"

With the alias gone, it works...

strange isn't it