Comments by oula alsheikh (Top 53 by date)

the problem that i was able to enter debug mode but suddenly i couldn't

ofcourse you can

even though i used step into button in management studio
which is identical to F11
debug mode is not entered

iam executing a stored procedure
as
Exec MYProcedure and press F11
but the procedure executed with out entering debug mode

if we want to compare variable value with null we have to test if this variable is null first to use the is null condition in the clause
while you dont have to when using = operator in usual

thanks for info

thanks for your answer
but i found this solution most helpful

var MyProceduresNames = new List<string>();
var fileEntries = Directory.GetFiles(@"D", "*.*", SearchOption.AllDirectories).ToList().Where(s => s.EndsWith(".AnyDesiredsuffix"));
foreach (string fileName in fileEntries)
{
ResXResourceReader rr = new ResXResourceReader(fileName);
foreach (DictionaryEntry entry in rr)
{
MyProceduresNames.Add(entry.Key.ToString()) ;
}
}

i have the same problem in the same function
Have you found any solution to this problem
or to decrypt a stored procedure

thanks a lot you cant imagine how much happy i am
because i searched alot and all the solutions i founded needed the form to be opened in run mode
and how much difficult it will be to get controls in this way
i really admire your efforts

thanks but this solution includes form open i mean the form must be opened at run time to get its controls
what i need and maybe is impossible is a way to get the controls with out the need to open the form at run time

that's right there is a huge difference
between c# and access

thanks but i want access code i mean vba

and here is the link for the last code http://www.access-programmers.co.uk/forums/showthread.php?t=246348

sorry you are right here is the code


[CODE]
Public Sub ScanDocs()
Const wiaFormatJPEG = "{B96B3CAE-0728-11D3-9D7B-0000F81EF32E}"
Dim strFileName As String
Dim Dialog1 As New WIA.CommonDialog, DPI As Integer, PP As Integer, l As Integer
Dim Scanner As WIA.Device
Dim img As WIA.ImageFile
Dim intPages As Integer
Dim strFileJPG As String
Dim i As Integer
Dim blnContScan As Boolean
Dim ContScan As String 'msgbox to chk if more pages are to be scanned
Dim PdfOverwrite As String 'msgbox to confirm pdf file overwite
Dim FSO As New FileSystemObject
Dim strFilePDF As String
Dim RptName As String
Dim strProcName As String
strProcName = "ScanDocs"
On Error GoTo Handle_Err

'empty the scantemp table
DoCmd.SetWarnings False
DoCmd.RunSQL "delete from scantemp"
DoCmd.SetWarnings True
strFileName = strDocType
'create a temp folder if it does not exists
CreateTempFolder
'if a temp folder is present, delete all files from it
DeleteFiles
'Code for scanning
'Must include reference to Microsoft Windows Image Acquisition 2.0 dll
blnContScan = True
intPages = 0
Do While blnContScan = True
DPI = 200
PP = 1 'No of pages
Set Scanner = Dialog1.ShowSelectDevice(WIA.WiaDeviceType.Scanner DeviceType, False, False)
With Scanner.Items(1)
.Properties("6146").Value = 1 'Colour intent (1 for color, 2 for grayscale, 4 for b & w)
.Properties("6147").Value = DPI 'DPI horizontal
.Properties("6148").Value = DPI 'DPI vertical
.Properties("6149").Value = 0 'x point to start scan
.Properties("6150").Value = 0 'y point to start scan
.Properties("6151").Value = 8.27 * DPI 'Horizontal extent
.Properties("6152").Value = 11.69 * DPI 'Vertical extent for letter
End With
Set img = Dialog1.ShowTransfer(Scanner.Items(1), wiaFormatJPEG, True)
'Set img = Scanner.Items(1).Transfer(WIA.FormatID.wiaFormatJP EG)
intPages = intPages + 1
strFileJPG = strTempFolder & "\" & strFileName & Trim(Str(intPages)) & ".jpg"
' If FSO.FileExists(strFileJPG) Then
' FSO.DeleteFile (strFileJPG)
' End If
' Set FSO = Nothing
img.SaveFile (strFileJPG)
DoCmd.SetWarnings False
DoCmd.RunSQL "insert into scantemp (picture) values ('" & strFileJPG & "')"
DoCmd.SetWarnings True
Set Scanner = Nothing
Set img = Nothing
strFileJPG = ""
'Prompt user if there are additional pages to scan
ContScan = MsgBox("Scan another page?", vbQuestion + vbYesNo, "Continue...?")
If ContScan = vbNo Then
blnContScan = False
End If
Loop
GoTo StartPDFConversion
StartPDFConversion:
strFilePDF = strTempFolder & "\" & strFileName & ".pdf"
If FSO.FileExists(strFilePDF) Then
FSO.DeleteFile (strFilePDF)
End If
Set FSO = Nothing
'Now let's run an Access report called rptScan and output it to a PDF file on the network
'rptScan is an Access report whose recordsource is the scantemp table
RptName = "rptScan"
DoCmd.OpenReport RptName, acViewReport, , , acHidden
DoCmd.Close acReport, RptName, acSaveYes
DoCmd.OutputTo acOutputReport, RptName, acFormatPDF, strFilePDF
CustDocPath = strFilePDF
strFilePDF = ""
Handle_Exit:
Exit Sub
Handle_Err:
Select Case err.Description
Case "The user requested a scan and there are no documents left in the document feeder."
MsgBox "Please insert paper into the scanner.", vbCritical, "Warning"
Resume
Case "ID Not Found."
MsgBox "Please check that your scanner is properly connected and powered on and try again later.", vbCritical, "Warning"
Resume Handle_Exit
Case "No such interface supported."
MsgBox "Please check that your scanner is properly connected and powered on and try again later.", vbCritical, "Warning"
Resume Handle_Exit
Case "User cancelled."
MsgBox "Scan cancelled by user.", vbCritical, "Warning"
Resume Handle_Exit
Case "The remote procedure call failed.."
MsgBox "RPC failed. Please check scanner settings in windows.", vbCritical, "Warning"
Resume Handle_Exit
Case Else
MsgBox "Oops! Something went wrong." & vbCrLf & vbCrLf & _
"In Function:" & vbTab & strProcName & vbCrLf & _
"Err Number: " & vbTab & err.Number & vbCrLf & _
"Description: " & vbTab & err.Description, vbCritical, _
"Error in " & Chr$(34)

VBA

no i dont want to change it programmatically but what do you mean under paragraph i cant find this option
my crystal report version is 13.0.2

Did you mean the last line should have the following syntax
EXEC sp_executesql @sSQL, @ParmDefinition, @result=@resultOUT OUTPUT

itried this but i got the error
Must declare the scalar variable "@resultOUT".

can you test the code for me and give me the solution please

iam thinking to use cursor for select columns that has identity and test if tablename is one of them but that costs me to loop for all tables in every time i want to test a specific tablename i think that is not an ideal way to test if table has identity or not

i tried this but it doesn't work too @result has no value

in first statement i alter the table and add a acolumn having the word spare so it exists

i mentioned that there is no error when i call the procedure in Sql Server Management Studio the problem is not from sp_rename or i think it is not from procedure but from calling the procedure

No iam using another procedure but it is written in same way and it works fine

Thanks very much Sumit i think it is going to be unsolved
what confused me that i have another function that is similar to that function and it works in normal way but this didn't what is the reason ?

i tried both solutions and the problem still appears

how can i add picture to question because i countered a problem and i cant express it by words

i have a form having components (textboxes,comboboxes)
these components are bound to table in a datacontext through
binding source
i want to know if any change occurs to text property of textbox without handling each textbox
what should i use ?what about PropertyChangedEventHandler
does it handles my situation
or i should iterate through textboxes and define event handler for textchanged?

textboxes and comboboxes

iam sure that the table name is correct its not my problem
i got the exception maybe when there is no select
available am i right?

i installed sp1 on windows server 2008
and run sql server but i encountered the following error
Error Code 0x84B20001
The action type 'ExecuteWorkflowAction' is not valid for the
WorkflowIdentity elemnt .The only valid action type is ExecuteWorkflowAction
what to Do?

please any one has answer??

Thanks very much for your answer panel1.controls.Clear()
that's what i was looking for
i think the link page should include this information to be complete
about this and its use i know what you explained any way thanks for your clarification and interest

i am interested in transferring the data from one database to
another that has the same schema so i am not working on transferring the schema
any one has a stored procedure ?

it works well thanks for your efforts

it works well thanks for your efforts

the first solution worked as follows
Set @UpdateStatement = 'Update ' + @tablename + ' Set ' + @PrimaryKey + '_Spare' + '=''' + convert(nvarchar(36),@IDValue)+ ''' Where ' + @PrimaryKey + '=' + Convert(nvarchar,@ID)

you have to add ''
thanks very much DamithSl

please can you give me a solution ????

i tried it it works as syntax
but it throws exception in execution in UpdateStatement:
Arithmetic overflow error converting expression to data type nvarchar.

you are right it is not the actual code because actual code is complicated
i put the algorithm of the code in a way of code

i wanted to rate the solution as 5 but i pressed one in a wrong way
how can i correct that?

what about newid() in sql does it guarantees uniqueness?

thanks i got confused because of this two pages
can you please read them
http://stackoverflow.com/questions/18472251[^]


http://forums.asp.net/t/364242.aspx[^]

thanks very much it works well
putting ' as ''' in @strsql was what i didn't
know how to make

i want to concentrate on speed and reliability can you help me please
according to many essays access cant handle more than 10 users and it has a big probability to be in a database crash and network bottleneck

iam working in a company that depends on access program
and now we want to deploy this program in C#.net
i have not done testing so before testing i want your experience
because i want to convince them by .net i think it is quicker?

windows form application and the datacontext is linq to sql

thanks i think this is a very good idea to put a section for site the record came from
in this way i can ensure that there will be no conflict

i didn't understand what you meant by definitely a starting point can you explain more?