I think the last choise for me but i will add new field "LineNum" to
LedgerTrans. Because voucher and transdate is not enough for me.
Anil Ozay
_____
From: Amit Jain [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 12:15 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] SQL error when log into Axapta -
Invalid Object Name 'SQLSYSTEMVARIABLES'
Hi Anil,
Each transaction in the ledgerjournalTrans and LedgerTrans are related
to each other by transdate and voucher and whereas the case of relation
of one line of voucher to its transaction is concerned i think there is
no relation other then voucher and transdate. thats why whenever you
see the voucher from any of the line in ledgerjournaltrans, Ledgertrans
table show all the lines of the same voucher number and transdate. If
you want to designate a particular ledgertrans with ledgerjournaltrans
by mean of line number may be you can create another field called
linenum in the table. I hope it helps.
This is what i know. If you get to know anything about the relation
within linnum also then please let me know.
Regards
Amit
Anil Ozay <[EMAIL PROTECTED]> wrote: Hi.. This problem generally
occurs when sql server system rights
changed. For ex, if you use "bmssa" user to connect to sql server, and
if owner of many tables in AXDB is "dmo", you can't select records. So
this message occurs. You should change the owners of tables.
Regards
Anil
_____
From: mchiat [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 5:22 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] SQL error when log into Axapta - Invalid
Object Name 'SQLSYSTEMVARIABLES'
Hi all,
Could anyone of you help me to resolve the problem? When i want to
log into axapta the following SQL error occurs
SQL has reported the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object
name `SQLSYSTEMVARIABLES'
You may refer to the error log file for further details.
Retry the operation?
If i click 'Yes' the same message box will keep on emerging. However
if i click 'No' the following message will appear:
Cannot select a record in ().
The SQL database has issued an error.
If i proceed the following message will appear:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name `SQLSYSTEMVARIABLES'. [SELECT VALUE FROM SQLSYSTEMVARIABLES
WHERE PARM = `SYSVARID']
If i continue the system will ask me to enter System Variables:
One or more SQL system variables are unknown.
System variable STR
Permitted values Text
New value
After i enter the New Value as VARCHAR(%u)the system will
automatically exit and if i want to log into Axapta again the same
SQL error will appear.
May i know what is happening? Is there anyway to resolve the
problem?
Hope you all can reply to me as soon as possible. Thank you in
advance.
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://rd.yahoo.com/SIG=129t3vmva/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705006764:HM/EXP=1085209839/A=2128215/R=0/SIG=10se96mf6/*http:/c
ompanion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=504037943>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://rd.yahoo.com/SIG=129i9lp9f/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705006764:HM/EXP=1085219504/A=2128215/R=0/SIG=10se96mf6/*http:/c
ompanion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=342608724>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
