Gurus (& SQL Question)

bri...@access5.digex.net (Brian G.)

Delphi Developer

Sun, 17 Oct 1999 03:00:00 GMT

Seeking Baltimore Users Group/Gurus (& SQL Question)

Is there a Baltimore, MD users group for Delphi? If so, can you give
me some contact information on it? TIA!

Also, if there are any people in or around Baltimore that might be willing
to help me out with a problem I've been having, I'd greatly appreciate it.

I've got a Delphi 1.0 app talking to a MSSQL 6.0 server and whenever it
is being updated by more than one person, even updating different records,
it locks the database up.

I am also getting what looks like chopped off SQL statements (the ends
are missing) in the "Current Activity" page when this happens.

Any Ideas/Help Welcome!

- Brian G.

ArtSmit

Delphi Developer

Sat, 23 Oct 1999 03:00:00 GMT

Re:Seeking Baltimore Users Group/Gurus (& SQL Question)

Brian,

Quote

> Is there a Baltimore, MD users group for Delphi? If so, can you give
> me some contact information on it? TIA!

I don't think that there is a balto area users group for Delphi :-(

Quote

> I've got a Delphi 1.0 app talking to a MSSQL 6.0 server and whenever it
> is being updated by more than one person, even updating different
records,
> it locks the database up.

MS SQL Server uses a page locking scheme instead of row level locking.
If the records being inserted or updated are close to each other chances
are
that their is page lock in effect.

Quote

> I am also getting what looks like chopped off SQL statements (the ends
> are missing) in the "Current Activity" page when this happens.

No sure about this one, sorry

Art.

Other Threads

1. MIT s/w guru seeks offsite work - C++/Delphi/SQL/Sybase DBA/Unix/NT/CTI/Internet

2. MIT s/w guru seeks offsite work - C++/Delphi/SQL/Sybase DBA/Unix/NT/CTI/Internet

3. MIT s/w guru seeks offsite work - C++/Delphi/SQL/Sybase DBA/Unix/NT/CTI/Internet

4. Meeting: Delphi Users Group (SIG of Capital PC User Group)

5. SQL challenge (GROUP BY) for gurus

6. VB Guru/Delphi Guru Please Help Me with OLE question

7. MIT software guru, database expert, seeks offsite work

8. V.entusiastic learner seeks guru

9. 2 seconds question for SQL Anywhere 5.0.02 gurus, please

10. A Question on DISTINCT for the SQL Gurus...