It works great.
Thanks
Jeremy
-----Original Message-----
From: jeremyrleonard@...
To: vantage@yahoogroups.com
Sent: Tue, 14 Mar 2006 11:42:10 -0500
Subject: Re: [Vantage] V6.1: SQL Server and Record Locking
I will try that. Thanks
-----Original Message-----
From: Stelios Zoumis <s.zoumis@...>
To: vantage@yahoogroups.com
Sent: Tue, 14 Mar 2006 09:03:49 +0200
Subject: RE: [Vantage] V6.1: SQL Server and Record Locking
If you are using SQL Commands write the statement with (nolock).
--------------------------------------------
Stelios Zoumis
Senior ERP Consultant
Financial Products & Solutions Department
ATC S.A.
Tel: +30 210 6874300
Fax: +30 210 6874321
10, Rizariou str, 152 33
Halandri, Athens, GREECE
E-mail <<<mailto:s.zoumis@... <BLOCKED::mailto:s.zoumis@...> >>>
===================================
This e-mail correspondence is confidential and intended for the named
recipient(s) only. The information contained in this e-mail and any
attachments may be confidential and/or protected by copyright. If the
reader of this e-mail is not intended recipient or the person
responsible for delivering it to the intended recipient, any copying,
distribution, publication or other use of, or taking of any action in
reliance upon, this e-mail is strictly prohibited. Should you have
received this e-mail in error, you are requested to notify ATC S.A. and
to delete this message and any attachments imm
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jeremyrleonard@...
Sent: Monday, March 13, 2006 8:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.1: SQL Server and Record Locking
Hello,
I'm working on the test conversion from a Progress to SQL Database and I
have run into a snag.
As an example, if I am in the Order Dtl screen entering a line, I have a
button you can click on that shows the stock status of the part you just
entered. My problem is, with the SQL database, the record is locked so
the stock status times out or is not availabe till I exit the Order Dtl
screen.
Anyone else run into this and maybe have a work around?
I have duplicated the results with ADO in Visual Basic in read only mode
and in SQL Query Analizer.
I would also have a problem if I was running a custom stock status
report for all parts and someone was in an Order Dtl line. The report
would hang until the record is released. I didn't have this issue with
the Progress database. Progress seems to do a better job of releaseing
the record. I normally wouldnt have this problem with SQL Server. I
think its the Dataserver product.
Any advice would be great.
Thanks
Jeremy
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Thanks
Jeremy
-----Original Message-----
From: jeremyrleonard@...
To: vantage@yahoogroups.com
Sent: Tue, 14 Mar 2006 11:42:10 -0500
Subject: Re: [Vantage] V6.1: SQL Server and Record Locking
I will try that. Thanks
-----Original Message-----
From: Stelios Zoumis <s.zoumis@...>
To: vantage@yahoogroups.com
Sent: Tue, 14 Mar 2006 09:03:49 +0200
Subject: RE: [Vantage] V6.1: SQL Server and Record Locking
If you are using SQL Commands write the statement with (nolock).
--------------------------------------------
Stelios Zoumis
Senior ERP Consultant
Financial Products & Solutions Department
ATC S.A.
Tel: +30 210 6874300
Fax: +30 210 6874321
10, Rizariou str, 152 33
Halandri, Athens, GREECE
E-mail <<<mailto:s.zoumis@... <BLOCKED::mailto:s.zoumis@...> >>>
===================================
This e-mail correspondence is confidential and intended for the named
recipient(s) only. The information contained in this e-mail and any
attachments may be confidential and/or protected by copyright. If the
reader of this e-mail is not intended recipient or the person
responsible for delivering it to the intended recipient, any copying,
distribution, publication or other use of, or taking of any action in
reliance upon, this e-mail is strictly prohibited. Should you have
received this e-mail in error, you are requested to notify ATC S.A. and
to delete this message and any attachments imm
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jeremyrleonard@...
Sent: Monday, March 13, 2006 8:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.1: SQL Server and Record Locking
Hello,
I'm working on the test conversion from a Progress to SQL Database and I
have run into a snag.
As an example, if I am in the Order Dtl screen entering a line, I have a
button you can click on that shows the stock status of the part you just
entered. My problem is, with the SQL database, the record is locked so
the stock status times out or is not availabe till I exit the Order Dtl
screen.
Anyone else run into this and maybe have a work around?
I have duplicated the results with ADO in Visual Basic in read only mode
and in SQL Query Analizer.
I would also have a problem if I was running a custom stock status
report for all parts and someone was in an Order Dtl line. The report
would hang until the record is released. I didn't have this issue with
the Progress database. Progress seems to do a better job of releaseing
the record. I normally wouldnt have this problem with SQL Server. I
think its the Dataserver product.
Any advice would be great.
Thanks
Jeremy
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
[Non-text portions of this message have been removed]