Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem with Insert SQL
I was able to get this to work strSQL = "INSERT INTO tblCommissionsPaid ([ContractNumber], [RepID], [CommAmt], [CommDate], [CommTypeID]) " & _ "VALUES ('" & Me.ContractNumber & "', " & Me.RepID & ", " & Me.PurchAmt * 0.15 & ", " & _ " #" & Me.ContractDate & "#, 2)" I'm still not sure if this...- webopdoug
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with Insert SQL
I was using the following syntax in a Private Function when Access complained "Invalid SQL Statement": Dim strSQL As String Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Set conn = CurrentProject.Connection Set rs = New ADODB.Recordset strSQL = "tblCommissionsPaid" rs.Open strSQL...- webopdoug
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Converting Korn to Bash syntax
Perfect. I used echo -n "." asldl38015: pause 10 .......... Thank you.- webopdoug
- Post #5
- Forum: UNIX Scripting
-
Converting Korn to Bash syntax
Not what I was looking for... What I want to see is "dot dot dot" etc across the screen until the timer times out. The output to screen should liook something like this... do something here . . . . . . . . . do something here . . . . . end It works in Korn shell but not in Bash. THe output in...- webopdoug
- Post #3
- Forum: UNIX Scripting
-
Converting Korn to Bash syntax
I use the following in a UNIX Korn shell script while [ i -lt $time ]; do echo ".\c" sleep 1 let i=i+1 done It produces a ....... string to actively show the script is pausing. This doesn't work with Bash. the result is ./c ./c...- webopdoug
- Thread
- Replies: 5
- Forum: UNIX Scripting
