I'm trying to create a getFunction that returns a single value from an sql
table (the next sequence number actually in a group of records). I tried two
different methods, a command and data adaptor. Here is the code:
Private Function getNextSeq()
Dim strsql
Dim lds As DataSet = New DataSet()
strsql = "select max(cmt_seq_No) from oelincmt_sql where ord_No = '"
& gstrOrder & "'" _
& " line_seq_no = 0" & " Ord_type = '" & "O" & "'"
' the following 2 lines of code errored out:
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
getNextSeq = cmd.ExecuteScalar
'then I tried this code which also errored out
Dim lda As SqlDataAdapter = New SqlDataAdapter(strsql, sqlConn)
lda.Fill(lds, "nextSeqNo")
getNextSeq = lds.Tables("nextSeq").Rows(0).Item(0)
end function
I would apreciate some advice as to the recommended way to create such a
function?
7  4067 
Your first approach seems like the way to go. You did not give the error
message so it is hard to know exactly what the issue is. However, one
suggestion is the ExecuteScalar method returns an object and you will need
to cast the return value to the appropriate data type.
If that does not solve the issue, please post the exact error message you
are receiving.
--
David Lloyd
MCSD .NET http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:F2**********************************@microsof t.com...
I'm trying to create a getFunction that returns a single value from an sql
table (the next sequence number actually in a group of records). I tried two
different methods, a command and data adaptor. Here is the code:
Private Function getNextSeq()
Dim strsql
Dim lds As DataSet = New DataSet()
strsql = "select max(cmt_seq_No) from oelincmt_sql where ord_No = '"
& gstrOrder & "'" _
& " line_seq_no = 0" & " Ord_type = '" & "O" & "'"
' the following 2 lines of code errored out:
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
getNextSeq = cmd.ExecuteScalar
'then I tried this code which also errored out
Dim lda As SqlDataAdapter = New SqlDataAdapter(strsql, sqlConn)
lda.Fill(lds, "nextSeqNo")
getNextSeq = lds.Tables("nextSeq").Rows(0).Item(0)
end function
I would apreciate some advice as to the recommended way to create such a
function?
Note the COALESCE function which ensures the SELECT will return a "1" even
if the results of the query are NULL. Also, the AND operators between
conditions in the WHERE clause of the SQL command.
Private Function getNextSeq() As Integer
Dim strsql As String
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " &
" AND Ord_type = @ord_Type"
sqlcmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 255).Value =
gstrOrder
sqlcmd.Parameters.Add("@ord_Type", SqlDbType.VarChar, 255).Value =
"O"
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
getNextSeq = cmd.ExecuteScalar
sqlcmd.Dispose()
End Function
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:F2**********************************@microsof t.com... I'm trying to create a getFunction that returns a single value from an sql
table (the next sequence number actually in a group of records). I tried
two
different methods, a command and data adaptor. Here is the code:
Private Function getNextSeq()
Dim strsql
Dim lds As DataSet = New DataSet()
strsql = "select max(cmt_seq_No) from oelincmt_sql where ord_No =
'"
& gstrOrder & "'" _
& " line_seq_no = 0" & " Ord_type = '" & "O" & "'"
' the following 2 lines of code errored out:
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
getNextSeq = cmd.ExecuteScalar
'then I tried this code which also errored out
Dim lda As SqlDataAdapter = New SqlDataAdapter(strsql, sqlConn)
lda.Fill(lds, "nextSeqNo")
getNextSeq = lds.Tables("nextSeq").Rows(0).Item(0)
end function
I would apreciate some advice as to the recommended way to create such a
function?
Excellent, we're getting there. I liked Michael's function better so I used
it. It looks like you are correct about the data type issue. Here's the error
I'm getting:
System.InvalidOperationException: ExecuteReader: CommandText property has
not been initialized
at System.Data.SqlClient.SqlCommand.ValidateCommand(S tring method,
Boolean executing)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at comments.Form1.getNextSeq() in
G:\Shared\VBShare\dotnet\Kevin\comments\Form1.vb:l ine 224
<<
I'm not sure how to correct it. Please advise. For the record Michael's sql
statement works perfectly in query analyzer.
"David Lloyd" wrote:
Your first approach seems like the way to go. You did not give the error
message so it is hard to know exactly what the issue is. However, one
suggestion is the ExecuteScalar method returns an object and you will need
to cast the return value to the appropriate data type.
If that does not solve the issue, please post the exact error message you
are receiving.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:F2**********************************@microsof t.com...
I'm trying to create a getFunction that returns a single value from an sql
table (the next sequence number actually in a group of records). I tried two
different methods, a command and data adaptor. Here is the code:
Private Function getNextSeq()
Dim strsql
Dim lds As DataSet = New DataSet()
strsql = "select max(cmt_seq_No) from oelincmt_sql where ord_No = '"
& gstrOrder & "'" _
& " line_seq_no = 0" & " Ord_type = '" & "O" & "'"
' the following 2 lines of code errored out:
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
getNextSeq = cmd.ExecuteScalar
'then I tried this code which also errored out
Dim lda As SqlDataAdapter = New SqlDataAdapter(strsql, sqlConn)
lda.Fill(lds, "nextSeqNo")
getNextSeq = lds.Tables("nextSeq").Rows(0).Item(0)
end function
I would apreciate some advice as to the recommended way to create such a
function?
Looks like I made a typo, and put the Dim sqlcmd line in the wrong place.
Try this:
Private Function getNextSeq() As Integer
Dim strsql As String
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " &
" AND Ord_type = @ord_Type"
Dim sqlcmd As SqlCommand = New SqlCommand(strsql, sqlConn)
sqlcmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 255).Value =
gstrOrder
sqlcmd.Parameters.Add("@ord_Type", SqlDbType.VarChar, 255).Value =
"O"
getNextSeq = cmd.ExecuteScalar
sqlcmd.Dispose()
End Function
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:E9**********************************@microsof t.com... Excellent, we're getting there. I liked Michael's function better so I
used
it. It looks like you are correct about the data type issue. Here's the
error
I'm getting:
System.InvalidOperationException: ExecuteReader: CommandText property has
not been initialized
at System.Data.SqlClient.SqlCommand.ValidateCommand(S tring method,
Boolean executing)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at comments.Form1.getNextSeq() in
G:\Shared\VBShare\dotnet\Kevin\comments\Form1.vb:l ine 224
<<
I'm not sure how to correct it. Please advise. For the record Michael's
sql
statement works perfectly in query analyzer.
"David Lloyd" wrote:
Your first approach seems like the way to go. You did not give the error
message so it is hard to know exactly what the issue is. However, one
suggestion is the ExecuteScalar method returns an object and you will
need
to cast the return value to the appropriate data type.
If that does not solve the issue, please post the exact error message you
are receiving.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or
warranties.
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:F2**********************************@microsof t.com...
I'm trying to create a getFunction that returns a single value from an
sql
table (the next sequence number actually in a group of records). I tried
two
different methods, a command and data adaptor. Here is the code:
Private Function getNextSeq()
Dim strsql
Dim lds As DataSet = New DataSet()
strsql = "select max(cmt_seq_No) from oelincmt_sql where ord_No =
'"
& gstrOrder & "'" _
& " line_seq_no = 0" & " Ord_type = '" & "O" & "'"
' the following 2 lines of code errored out:
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
getNextSeq = cmd.ExecuteScalar
'then I tried this code which also errored out
Dim lda As SqlDataAdapter = New SqlDataAdapter(strsql, sqlConn)
lda.Fill(lds, "nextSeqNo")
getNextSeq = lds.Tables("nextSeq").Rows(0).Item(0)
end function
I would apreciate some advice as to the recommended way to create such a
function?
Michael,
I did rewrite it with the command in the right place as follows:
Private Function getNextSeq() As Integer
Dim strsql As String
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
cmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 8).Value = gstrOrder
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " & _
" AND Ord_type = 'O'"
Try
strsql = cmd.ExecuteScalar
Catch ex As Exception
Console.WriteLine(ex.ToString)
MessageBox.Show(ex.ToString)
End Try
cmd.Dispose()
End Function
But I still get error about the commandText property not being
initialized...as shown in previous post? Any advice?
Thanks,
Kevin
"Michael C#" wrote: Looks like I made a typo, and put the Dim sqlcmd line in the wrong place.
Try this:
Private Function getNextSeq() As Integer
Dim strsql As String
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " &
" AND Ord_type = @ord_Type"
Dim sqlcmd As SqlCommand = New SqlCommand(strsql, sqlConn)
sqlcmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 255).Value =
gstrOrder
sqlcmd.Parameters.Add("@ord_Type", SqlDbType.VarChar, 255).Value =
"O"
getNextSeq = cmd.ExecuteScalar
sqlcmd.Dispose()
End Function
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:E9**********************************@microsof t.com... Excellent, we're getting there. I liked Michael's function better so I
used
it. It looks like you are correct about the data type issue. Here's the
error
I'm getting:
System.InvalidOperationException: ExecuteReader: CommandText property has
not been initialized
at System.Data.SqlClient.SqlCommand.ValidateCommand(S tring method,
Boolean executing)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at comments.Form1.getNextSeq() in
G:\Shared\VBShare\dotnet\Kevin\comments\Form1.vb:l ine 224
<<
I'm not sure how to correct it. Please advise. For the record Michael's
sql
statement works perfectly in query analyzer.
"David Lloyd" wrote:
Your first approach seems like the way to go. You did not give the error
message so it is hard to know exactly what the issue is. However, one
suggestion is the ExecuteScalar method returns an object and you will
need
to cast the return value to the appropriate data type.
If that does not solve the issue, please post the exact error message you
are receiving.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or
warranties.
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:F2**********************************@microsof t.com...
I'm trying to create a getFunction that returns a single value from an
sql
table (the next sequence number actually in a group of records). I tried
two
different methods, a command and data adaptor. Here is the code:
Private Function getNextSeq()
Dim strsql
Dim lds As DataSet = New DataSet()
strsql = "select max(cmt_seq_No) from oelincmt_sql where ord_No =
'"
& gstrOrder & "'" _
& " line_seq_no = 0" & " Ord_type = '" & "O" & "'"
' the following 2 lines of code errored out:
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
getNextSeq = cmd.ExecuteScalar
'then I tried this code which also errored out
Dim lda As SqlDataAdapter = New SqlDataAdapter(strsql, sqlConn)
lda.Fill(lds, "nextSeqNo")
getNextSeq = lds.Tables("nextSeq").Rows(0).Item(0)
end function
I would apreciate some advice as to the recommended way to create such a
function?
You need to assign a value to strsql before you create the SqlCommand.
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " & _
" AND Ord_type = 'O'"
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
cmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 8).Value = gstrOrder
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:A4**********************************@microsof t.com... Michael,
I did rewrite it with the command in the right place as follows:
Private Function getNextSeq() As Integer
Dim strsql As String
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
cmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 8).Value =
gstrOrder
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " & _
" AND Ord_type = 'O'"
Try
strsql = cmd.ExecuteScalar
Catch ex As Exception
Console.WriteLine(ex.ToString)
MessageBox.Show(ex.ToString)
End Try
cmd.Dispose()
End Function
But I still get error about the commandText property not being
initialized...as shown in previous post? Any advice?
Thanks,
Kevin
"Michael C#" wrote:
Looks like I made a typo, and put the Dim sqlcmd line in the wrong place.
Try this:
Private Function getNextSeq() As Integer
Dim strsql As String
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " &
" AND Ord_type = @ord_Type"
Dim sqlcmd As SqlCommand = New SqlCommand(strsql, sqlConn)
sqlcmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 255).Value =
gstrOrder
sqlcmd.Parameters.Add("@ord_Type", SqlDbType.VarChar, 255).Value =
"O"
getNextSeq = cmd.ExecuteScalar
sqlcmd.Dispose()
End Function
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:E9**********************************@microsof t.com... > Excellent, we're getting there. I liked Michael's function better so I
> used
> it. It looks like you are correct about the data type issue. Here's the
> error
> I'm getting:
>>>
> System.InvalidOperationException: ExecuteReader: CommandText property
> has
> not been initialized
> at System.Data.SqlClient.SqlCommand.ValidateCommand(S tring method,
> Boolean executing)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteScalar()
> at comments.Form1.getNextSeq() in
> G:\Shared\VBShare\dotnet\Kevin\comments\Form1.vb:l ine 224
>
> <<
> I'm not sure how to correct it. Please advise. For the record Michael's
> sql
> statement works perfectly in query analyzer.
>
> "David Lloyd" wrote:
>
>> Your first approach seems like the way to go. You did not give the
>> error
>> message so it is hard to know exactly what the issue is. However, one
>> suggestion is the ExecuteScalar method returns an object and you will
>> need
>> to cast the return value to the appropriate data type.
>>
>> If that does not solve the issue, please post the exact error message
>> you
>> are receiving.
>>
>> --
>> David Lloyd
>> MCSD .NET
>> http://LemingtonConsulting.com
>>
>> This response is supplied "as is" without any representations or
>> warranties.
>>
>>
>> "KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
>> news:F2**********************************@microsof t.com...
>> I'm trying to create a getFunction that returns a single value from an
>> sql
>> table (the next sequence number actually in a group of records). I
>> tried
>> two
>> different methods, a command and data adaptor. Here is the code:
>> Private Function getNextSeq()
>> Dim strsql
>> Dim lds As DataSet = New DataSet()
>> strsql = "select max(cmt_seq_No) from oelincmt_sql where
>> ord_No =
>> '"
>> & gstrOrder & "'" _
>> & " line_seq_no = 0" & " Ord_type = '" & "O" & "'"
>> ' the following 2 lines of code errored out:
>> Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
>> getNextSeq = cmd.ExecuteScalar
>>
>> 'then I tried this code which also errored out
>> Dim lda As SqlDataAdapter = New SqlDataAdapter(strsql,
>> sqlConn)
>> lda.Fill(lds, "nextSeqNo")
>> getNextSeq = lds.Tables("nextSeq").Rows(0).Item(0)
>> end function
>>
>> I would apreciate some advice as to the recommended way to create such
>> a
>> function?
>>
>>
>>
Thank You very much - it works now.
"Michael C#" wrote: You need to assign a value to strsql before you create the SqlCommand.
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " & _
" AND Ord_type = 'O'"
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
cmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 8).Value = gstrOrder
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:A4**********************************@microsof t.com... Michael,
I did rewrite it with the command in the right place as follows:
Private Function getNextSeq() As Integer
Dim strsql As String
Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
cmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 8).Value =
gstrOrder
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " & _
" AND Ord_type = 'O'"
Try
strsql = cmd.ExecuteScalar
Catch ex As Exception
Console.WriteLine(ex.ToString)
MessageBox.Show(ex.ToString)
End Try
cmd.Dispose()
End Function
But I still get error about the commandText property not being
initialized...as shown in previous post? Any advice?
Thanks,
Kevin
"Michael C#" wrote:
Looks like I made a typo, and put the Dim sqlcmd line in the wrong place.
Try this:
Private Function getNextSeq() As Integer
Dim strsql As String
strsql = "SELECT COALESCE(MAX(cmt_seq_No), 0) + 1 " & _
" FROM oelincmt_sql " & _
" WHERE ord_No = @ord_No " & _
" AND line_seq_no = 0 " &
" AND Ord_type = @ord_Type"
Dim sqlcmd As SqlCommand = New SqlCommand(strsql, sqlConn)
sqlcmd.Parameters.Add("@ord_No", SqlDbType.VarChar, 255).Value =
gstrOrder
sqlcmd.Parameters.Add("@ord_Type", SqlDbType.VarChar, 255).Value =
"O"
getNextSeq = cmd.ExecuteScalar
sqlcmd.Dispose()
End Function
"KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
news:E9**********************************@microsof t.com...
> Excellent, we're getting there. I liked Michael's function better so I
> used
> it. It looks like you are correct about the data type issue. Here's the
> error
> I'm getting:
>>>
> System.InvalidOperationException: ExecuteReader: CommandText property
> has
> not been initialized
> at System.Data.SqlClient.SqlCommand.ValidateCommand(S tring method,
> Boolean executing)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteScalar()
> at comments.Form1.getNextSeq() in
> G:\Shared\VBShare\dotnet\Kevin\comments\Form1.vb:l ine 224
>
> <<
> I'm not sure how to correct it. Please advise. For the record Michael's
> sql
> statement works perfectly in query analyzer.
>
> "David Lloyd" wrote:
>
>> Your first approach seems like the way to go. You did not give the
>> error
>> message so it is hard to know exactly what the issue is. However, one
>> suggestion is the ExecuteScalar method returns an object and you will
>> need
>> to cast the return value to the appropriate data type.
>>
>> If that does not solve the issue, please post the exact error message
>> you
>> are receiving.
>>
>> --
>> David Lloyd
>> MCSD .NET
>> http://LemingtonConsulting.com
>>
>> This response is supplied "as is" without any representations or
>> warranties.
>>
>>
>> "KevinMGore" <Ke********@discussions.microsoft.com> wrote in message
>> news:F2**********************************@microsof t.com...
>> I'm trying to create a getFunction that returns a single value from an
>> sql
>> table (the next sequence number actually in a group of records). I
>> tried
>> two
>> different methods, a command and data adaptor. Here is the code:
>> Private Function getNextSeq()
>> Dim strsql
>> Dim lds As DataSet = New DataSet()
>> strsql = "select max(cmt_seq_No) from oelincmt_sql where
>> ord_No =
>> '"
>> & gstrOrder & "'" _
>> & " line_seq_no = 0" & " Ord_type = '" & "O" & "'"
>> ' the following 2 lines of code errored out:
>> Dim cmd As SqlCommand = New SqlCommand(strsql, sqlConn)
>> getNextSeq = cmd.ExecuteScalar
>>
>> 'then I tried this code which also errored out
>> Dim lda As SqlDataAdapter = New SqlDataAdapter(strsql,
>> sqlConn)
>> lda.Fill(lds, "nextSeqNo")
>> getNextSeq = lds.Tables("nextSeq").Rows(0).Item(0)
>> end function
>>
>> I would apreciate some advice as to the recommended way to create such
>> a
>> function?
>>
>>
>>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: bjam |
last post by:
Hi,
I am hoping someone can help with this I am assuming it is pretty
basic but I don't see anything that jumps out at me at how to do this.
Is there a way to have all the items output from the...
|
by: Mike Copeland |
last post by:
In the following code I am calculating 2 values when the "Compute
Distance" button is pressed. I would like to find a way to "return" both
value to the form so I can show both when the calculation...
|
by: Ann Huxtable |
last post by:
I have the following code segment - which compiles fine. I'm just
worried I may get run time probs - because it looks like the functions
are being overloaded by the return types?. Is this Ok: ?
...
|
by: eight02645999 |
last post by:
hi
i use odbc to update a table in a database but i always get return
value of -1
even though i tried to return an integer. the table is updated though
....
sql = """
update table
set column =...
|
by: Oberon |
last post by:
How do I deal with this? I am getting an error for each get in the
Game class (see code below).
In the simplified example below I have reduced this to just 3 fields,
one which can be NULL. I...
|
by: jjturon |
last post by:
Can anyone help me??
I am trying to pass a Select Query variable to a table using Dlookup
and return the value to same select query but to another field.
Ex.
SalesManID ...
|
by: Pedro Pinto |
last post by:
Hi there once more........
Instead of showing all the code my problem is simple.
I've tried to create this function:
char temp(char *string){
alterString(string);
return string;
|
by: thuythu |
last post by:
Please help me....
I used and Javascript to view the data. But when i click button open a popup windows, then select data and click save button. The popup close and return the main page, but the...
|
by: Sudarhan |
last post by:
Hello frnds
I have created a webbased form using asp and javascript .. while submitting the form i am validating the fields in the form .it validates the field and returns alert message. but when...
|
by: Eric Kaplan |
last post by:
I have a function like this
=============
bool Table::Get(char* FieldName, char* FieldValue)
and I call the function like the follow
=============
while(!tbl.ISEOF())
{
char id2;...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
