Search:

Also IMHO this code should not work!

for(int i=0;i<cmboboName.Items.Count;i++)
{
comboboxName.Items.RemoveAt(i); //VERY BAD IDEA!
i--;
}

The loop is incrementing index" while "RemoveAt"...

Could U send whole SP?

U have too many " ' " in output in ''TNGoedit_Data''

As I said before uU shold'nt use CHAR datat type. use VARCHAR (and use RTRIM() function too).
See:
'oBookingUFS '
'................ ^'

And is it a possibility that 'TNGoedit_Data' is really...

more comments:

1) Do not use "char" data type - use varchar instead. "char" can add extra spaces on the end in some circumstances.

2) The error will now be there :

for the same reason -...

replace this:

into this:

declare @path varchar(64),@filepath varchar(255)

and this:


into this:

Yes - because "single insert " can trigger more actions ...
And Yes - because it is good programming practise.

yes!

No! It is a value which sometimes (on errors) is returned by MsSQL server (internally). If U don't write "RETURN XXX" (where XXX is a place for any integer) then on success SP will return "0". If U...

MsSQL Server...
;-)

U should not depend on exact error value returned from stored procedure, because user CAN (but shouldnt) write code that return -4 as well. Better use exception handling...

yes
;)

because it (user/schema id) is in different column.
;-)

sp_helptext splits up that formal name and do exactly the same select

should be:


SELECT c.text
FROM sysobjects o
INNER JOIN syscomments c ON c.id=o.id
WHERE o.name='prc_AddABC'
ORDER BY colid

http://doc.ddart.net/mssql/sql70/ea-ez_2.htm

http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@ebt-link;pt=42965?target=%25N%15_43870_START_RESTART_N%25

It is a SYBASE, but ... U know... SYBASE=MsSQL.... almost.
;-)

Database is a "shared resource", not an isolated island. If one session locks up an object, than other session that will be trying to get that resource will be blocked until it will be released (for...

It is in Your database... I don't know its name ...
;-)

Try this:

SELECT c.text
FROM sysobjects o
INNER JOIN syscomments c ON c.id=o.id
WHERE o.name='YoursProcedureName'
ORDER BY colid

Some concepts...

First IsNull() OR "(Sales.Quarter = @QuarterXX OR @QuarterXX IS NULL)" (assumption is made that variables are set to null when "not set", not to "0" as in first, original ...

And that is a correct solution.
;-)
Create unique constraint to solve it (as mentioned above). But maybe also keep your checks, so U can resolve that gracefully (unique index will speed up that...

In database inside the "syscomments" table ....
;-)

Create 3 threads. In each thread:
1) Open connection
2) Execute SP
3) Close Connection

If U have 3 processors , there will be a slight chance that it will execute in parralel ..
;-)

Best...

http://www.google.com/search?hl=pl&q=try+catch+TSQL&lr=

Because there is a possibility that database will hold locks on objects that U modify. Message Box will stop normal program flow waiting for user input ... but user goes on holiday ...
;-)
Other...

yes.

:D

In menu: tools/startup - set up a startup form (which U created before)

Than add "global" code

Function ChangeProperty(strPropName As String, varPropType As Variant, varPropValue As Variant)...

for example:

IF EXISTS ( SELECT EmployeeID FROM Employee WHERE EmployeeID = @p_EmployeeID )

/* RETURN AN EXCEPTION */
RAISERROR('Employee already in database',16,1)
Return -1;