hello
i want to modify multiple rows in database with select option i am using R.update but it can update only one record in database but i wants to more then one record is modify after submit so what code i have to use i am using -
<%
-
If Not IsEmpty(Request.Form("submit")) then
-
vopenflg = Request.Form("vopenflg")
-
vopenflg=trim(vopenflg)
-
conn.close
-
conn.Mode = adModeReadWrite
-
conn.open
-
R1.open "Select open_flg from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText
-
R1("open_flg")= vopenflg
-
R1.update
-
R1.Close
-
end if
-
%>
20 2302
Put your update statement within a loop. Youcan loop through various rows of your recordset using the r1.movenext method, then modify that row as desired. Let me know if this helps.
Jared
PS. Your code belongs in code tags like this: [code=asp]'code goes here[/code]
hello,
Jared
when i am using this code it is not report any error or nither update any row
so where is the problems - 'code goes here
-
<% conn.close
-
If Not IsEmpty(Request.Form("submit")) then
-
vopenflg = Request.Form("vopenflg")
-
vopenflg=trim(vopenflg)
-
conn.Mode = adModeReadWrite
-
conn.open
-
R1.open "Select open_flg from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText
-
while R1.eof
-
R1("open_flg")= vopenflg
-
R1.update
-
R1.movenext
-
R1.Close
-
wend
-
end if
-
%>
hello,
Jared
when i am using this code it is not report any error or nither update any row
so where is the problems
another code is - 'code goes here
-
<% do until not R1.eof
-
R1("open_flg")= vopenflg
-
R1.update
-
R1.movenext
-
loop
-
R1.Close
-
end if
-
and by using the code do whiel not R1.eof instead of do until not R1.eof
error is multiple oledb
so what is
code should be "do until R1.eof...loop" or "while not R1.eof... wend" or some variation of this.
Jared
hello plz help in updation of data with multiple row. this code is my last modified code which is using today interchange the code but i found some error this code isn't generate any error but modification or updation is not done . os plz see again here -
R1.open "Select open_flg from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText
-
Do While Not R1.EOF
-
vopenflg=R1("open_flg")
-
R1.update
-
R1.MoveNext
-
loop
-
R1.Close
i am using this code then it update all records from table i am using pagingnation and show one record on page plz help in updae to selected rows only thaks -
<%conn.close
-
If Not IsEmpty(Request.Form("submit")) then
-
vopenflg = Request.Form("vopenflg")
-
vopenflg=trim(vopenflg)
-
conn.Mode = adModeReadWrite
-
conn.open
-
R1.open "Select open_flg from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText
-
R1("open_flg")=vopenflg
-
do while not R1.eof
-
R1.moveNext
-
loop
-
R1.update
-
R1.Close
-
conn.close
-
end if
-
%>
idsanjeev,
Since I am bilingual, I understand the difficulty you face in trying to express yourself in a foreign language. Please understand that you have not given enough information for me to answer the question fully. There are many possible ways in which someone may try to "update a database", and your question does not specify what you mean.
I assume that your user will see a table of data which approximates your database. He performs some action like clicking on a button or toggling a checkbox to indicate which records need to be modified. It looks from your question that the user sees a long list of records and next to each one there is a checkbox. He toggles the boxes he would like to update, then clicks a "submit" button. Am I right so far?
Please explain how the form is set up. This is important for me to find the best way to modify the database. If it is difficult for you to explain, please send the code for the form. When you post the code all of the code should be between the two code tags like this:
[code]
<%
dim rs1, query
query = "SELECT topOpenFlg FROM table1 WHERE recordID = "
query = query & request.form("recordID")
set rs1 = server.createobject("ADODB.Recordset")
rs1.open query, conn, 2,3
rs1("topOpenFlg") = date()
rs1.update
%>
[/code]
Jared
hi jhardman
thanks to reply
my deadline of project is very close if i cant submit till tomorw then this project is transferd to other. so please reply soon .
again explained my question what is my target.
i wants to show some records on page from table that can see all and modify any records i wants to modiy then a select list inside all records i.e no,yes,close ,
if i wants to modify any records from display rows then select option from rows inside called apply and click on submit and change only selected rows detail .
but i am in trouble by using this code i able to change all records from table also i am using pagignation to avoide error multiple oledb .
so my question is to help me to modify thats record i wants to modify that is on page so how can modify only thats which i wants.this is my full code plz check my code - code is here
-
-
<%@language=vbscript%>
-
<%option explicit%>
-
<%
-
If Request.Cookies("userid") = "" Then
-
Response.Redirect "login.asp"
-
Else
-
dim my_conn_stRing, conn,R,R1,R2, sql,Rcount,Rpage,page,i,vopenflg
-
dim stroutput,reply,repcount,stropt,vtopid
-
MY_CONN_STRING = "dsn=oracle;uid=starter;pwd=starter;"
-
Set Conn = server.createobject("ADODB.Connection")
-
Conn.open MY_CONN_STRING
-
set R = Server.CreateObject("ADODB.Recordset")
-
set R1 = Server.CreateObject("ADODB.Recordset")
-
set R2 = Server.CreateObject("ADODB.Recordset")
-
R.open "Select top_id,top_sub,launch_by,launch_dt from topmaster ",conn, adOpenStatic, adLockOptimistic, adCmdText
-
R.PageSize=1
-
Repcount=R.RecordCount
-
Rcount=R.RecordCount
-
Rpage=R.PageCount
-
if Request.QueryString("Reply")="" then
-
Reply=1
-
else
-
Reply=cint((Request.QueryString("Reply")))
-
end if
-
if Request.querystring("page")="" then
-
page=1
-
else
-
page=cint((Request.querystring("page")))
-
end if
-
%>
-
<html>
-
<head><TITLE>Vioce Of Baraunians</TITLE></head>
-
<body bgcolor="#FFFFFF" background="../SANJEEV/backphoto.gif">
-
<form name="moderator" action="moderator.asp" method="post">
-
<!--#include file="front.inc"--><br><br>
-
<meta http-equiv="Content-Type" content="text/html; charet=iso-8859-1">
-
<div style="position:absolute; top:100; left:0 ">
-
<table width="1000" border="0" cellspacing="1" cellpadding="3" bgcolor="#663333" >
-
<tr bgcolor="#CCCCFF">
-
<td width="8%" ><b>TOPIC ID</b></td>
-
<td bgcolor="#CCCCFF" colspan="100%"> <img src="files categories.gif"> <b>TOPIC SUBJECT</b></td>
-
<td bgcolor="#CCCCFF" width="12%"><img src="group user.gif"> <b>POSTED BY</b></td>
-
<td bgcolor="#CCCCFF" width="12%"><b>POSTED DATE</b></td>
-
<td bgcolor="#CCCCFF"><b>Permission</b></td>
-
</tr>
-
<%
-
if not R.eof then
-
R.Move (page-1)*R.pagesize
-
end if
-
if not R.eof then
-
for i=1 to R.pagesize
-
%>
-
<tr bgcolor="#FFFFFF">
-
<td bgcolor="#66FF99" width="8%"><%=R("top_id")%></td>
-
<td align="left" colspan="100%" bgcolor="#66FF99"><b><font face="arial" size=2><a href=voice.asp?opt=<%=R("top_id")%>><%Response.Write R("top_sub")%></a></font></b></td>
-
<td bgcolor="#66FF99" width="12%"><%=R("launch_by")%></td>
-
<td bgcolor="#66FF99" width="12%"><%=R("launch_dt")%></td>
-
<td width="10%"><font face="arial" size="2"><b>Apply</b></font>
-
<select name="vopenflg">
-
<%If IsEmpty(vopenflg) or vopenflg = 0 Then%>
-
<option value="0" selected>No</option>
-
<option value="1">Yes</option>
-
<option value="2">clsoe</option>
-
<%Elseif vopenflg =1 Then%>
-
<option value="0">No</option>
-
<option value="1" selected>Yes</option>
-
<option value="2">Close</option>
-
<%Elseif vopenflg =2 Then%>
-
<option value="0">No</option>
-
<option value="1">Yes</option>
-
<option value="2" selected>Close</option>
-
<%End If%>
-
</select>
-
</tr>
-
<%
-
if request.QueryString("opt") then
-
stropt=opt
-
end if
-
if request.QueryString("opt1") then
-
detail=request.QueryString("opt")
-
end if
-
R.movenext
-
If R.EOF Then
-
Exit For
-
end if
-
next
-
end if%>
-
</table>
-
<table width="1000" border="0" cellspacing="1" cellpadding="3" >
-
<tr align="right" bgcolor="#99FFFF">
-
<td><b>Voice of Baraunians views</b></td><td><%Response.write(Application("visitors"))%></td>
-
<td> <%If page>1 Then %> <a href="moderator.asp?page=<%=page-1%>">Previous</a>
-
<%end if %>
-
<% If page < rpage Then %> <a href="moderator.asp?page=<%=page+1%>">Next</a>
-
<% end if %>
-
<%if rpage>1 then
-
for i=1 to Rpage
-
Response.write "<a href=""moderator.asp?page="&i&""">"&i&"</a> "
-
next
-
end if%> </td>
-
</tr>
-
</table><br>
-
-
<%
-
If Not IsEmpty(Request.Form("submit")) then
-
vopenflg = Request.Form("vopenflg")
-
vopenflg=trim(vopenflg)
-
conn.close
-
conn.Mode = adModeReadWrite
-
conn.open
-
R1.Open "select open_flg from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText
-
do while not R1.eof
-
R1("open_flg")=vopenflg
-
R1.update
-
R1.movenext
-
loop
-
R1.Close
-
conn.close
-
end if
-
end if
-
%>
-
<table width=765>
-
<tr><td width="60%"></td>
-
<td><input type= "submit" name="submit" value="Apply" onclick="update()">
-
<input type="button" name="submit" value="Back" onclick="brvoice()">
-
<input type ="button" value="EXIT" onClick="window.close()"></td>
-
</tr>
-
</table>
-
<script language="Javascript">
-
function brvoice()
-
{
-
window.location = "brvoice.asp"
-
}
-
-
function update()
-
{
-
window.location = "moderator.asp"
-
}
-
-
</script>
-
</div>
-
</form>
-
</body>
-
</html>
-
hi jhardman
is not clear my question .i wants to show records on page that have one column for select list to modify. i wants select option from list and modify after apply button is pressed but only those row that is selected is possible if not then give me other idea to find records and update after modify so plz understand from both posting and answer to my question.thanks
hi jhardman
is not clear my question .i wants to show records on page that have one column for select list to modify. i wants select option from list and modify after apply button is pressed but only those row that is selected is possible if not then give me other idea to find records and update after modify so plz understand from both posting and answer to my question.thanks
I think I understand what you are asking. Your form is set up very poorly for what you are attempting and you will need to change it. The biggest problem is that each of the select boxes has the same name. There is no way for the script which handles the form to distinguish between the different select boxes or decide which corresponds to which record in the database. In fact if you were to write this: - response.write request("vopenflg")
it would print out - yes,yes,no,close,yes,no,no,no,close,yes
or something similar. You will either need to split up this info into an array or give each of the select boxes a different name. I would suggest you give each a different name and in this way you can also indicate which select box corresponds to which row in the database. You understand that each record in a database has a unique field called a "key" or "identifier" right? I usually call my key field "ID" or something similar, so I will guess that yours is called "top_id". Is this right? If so, you may name each select box like this: - <select name="vopenflg<%=R("top_id")%>">
this will give each of the select boxes a unique name like this: "vopenflg135", "vopenflg146", etc. Do you understand? Not only do they each have different names, the name indicates to which record it corresponds.
On the part of the script which handles the form, you can use the name of the select box to indicate which record needs to be updated. simply loop through the database the same way you did the first time, and update like this: - if request("vopenflg" & R1("top_id")) <> "" then
-
R1("open_flg")=vopenflg
-
R1.update
-
end if
hi jhardman
this is not help i think something wrong but what is i don't Understand.so plzcan you give me code how to modify form which is need if one or more then on rows are disply but modify only selected rows.
hi jhardman
this is not help i think something wrong but what is i don't Understand.so plzcan you give me code how to modify form which is need if one or more then on rows are disply but modify only selected rows.
No, as I said before, the code depends too much on your set up and your site specifications. I have tried to explain the general idea, but the actual code will need to be custom-made, and that is your job. If you want me to make it for you, I would expect to be paid for it.
Jared
hi jhardman by using this code no any updation and error so plz where is the problems.thanks -
-
<select name="vopenflg <%=R("top_id")%>">
-
<%If IsEmpty(vopenflg) or vopenflg = 0 Then%>
-
<option value=" " selected>Normal</option>
-
<option value="0">Abuse</option>
-
<option value="1">clsoe</option>
-
<%Elseif vopenflg =1 Then%>
-
<option value=" " >Normal</option>
-
<option value="0" selected>Abuse</option>
-
<option value="1">clsoe</option>
-
<%Elseif vopenflg =2 Then%>
-
<option value=" " >Normal</option>
-
<option value="0" >Abuse</option>
-
<option value="1" selected>clsoe</option>
-
<%End If%>
-
</select>
-
<% R.close
-
If Not IsEmpty(Request.Form("submit")) then
-
vopenflg = Request.Form("vopenflg")
-
vopenflg=trim(vopenflg)
-
conn.close
-
conn.Mode = adModeReadWrite
-
conn.open
-
R.open "select top_id,open_flg from topmaster ",conn, adOpenStatic, adLockOptimistic, adCmdText
-
if request.QueryString("vopenflg"& R("top_id"))<>"" then
-
R("open_flg")=vopenflg
-
R.update
-
R.Close
-
conn.close
-
end if
-
end if
-
end if
-
%>
-
hi i am change my logic like this link with another page top_id and topicsubject on click topic subject its detail is display on next page called update1.asp i wants to upadta the displyed details column open_flg status plz this is my code for display and update this is display link wise detail but not update so help in updation -
<%@language=vbscript%>
-
<%option explicit%>
-
<%
-
If Request.Cookies("userid") = "" Then
-
Response.Redirect "login.asp"
-
Else
-
dim my_conn_stRing, conn,R,R1,R2, sql,Rcount,Rpage,page,i,vopenflg
-
dim stroutput,reply,repcount,stropt1,vtopid
-
MY_CONN_STRING = "dsn=oracle;uid=starter;pwd=starter;"
-
Set Conn = server.createobject("ADODB.Connection")
-
conn.mode=admodereadwrite
-
Conn.open MY_CONN_STRING
-
set R = Server.CreateObject("ADODB.Recordset")
-
for each stropt1 in request.QueryString
-
vtopid=request.QueryString(stropt1)
-
R.open "Select top_id,top_sub,MSG,open_flg,launch_by,launch_dt from topmaster where top_id="&vtopid&" order by top_id desc ",conn, adOpenStatic, adLockOptimistic, adCmdText
-
%>
-
<html>
-
<head><TITLE>Vioce Of Baraunians</TITLE></head>
-
<body bgcolor="#FFFFFF" background="back.gif">
-
<form name="update" action="update1.asp" method="post">
-
<!--#include file="front.inc"--><br><br>
-
<meta http-equiv="Content-Type" content="text/html; charet=iso-8859-1">
-
<div style="position:absolute; top:100; left:0 ">
-
<table width="1000" border="0" cellspacing="1" cellpadding="3" bgcolor="#663333" >
-
<tr bgcolor="#CCCCFF">
-
<td width="8%" ><b>TOPIC ID</b></td>
-
<td bgcolor="#CCCCFF" colspan="50%"> <b>TOPIC SUBJECT</b></td>
-
<td bgcolor="#CCCCFF" colspan="50%"><b>MESSAGE</b></td>
-
<td bgcolor="#CCCCFF" width="12%"> <b>POSTED BY</b></td>
-
<td bgcolor="#CCCCFF" width="12%"><b>POSTED DATE</b></td>
-
<td bgcolor="#CCCCFF"><b>Permission</b></td>
-
</tr>
-
<tr bgcolor="#FFFFFF">
-
<td bgcolor="#66FF99" width="8%"><%=R("top_id")%></td>
-
<td align="left" colspan="50%" bgcolor="#66FF99"><b><font face="arial" size=2><%Response.Write R("top_sub")%></font></b></td>
-
<td bgcolor="#66FF99" COLSPAN="50%"><%=R("msg")%></td>
-
<td bgcolor="#66FF99" width="12%"><%=R("launch_by")%></td>
-
<td bgcolor="#66FF99" width="12%"><%=R("launch_dt")%></td>
-
<td width="10%"><font face="arial" size="2"><b>Apply</b></font>
-
<select name="vopenflg">
-
<option value=" " >Normal</option>
-
<option value="0" >Abuse</option>
-
<option value="1">clsoe</option>
-
</select>
-
</tr>
-
</table>
-
<table width="1000" border="0" cellspacing="1" cellpadding="3" >
-
<tr align="right" bgcolor="#99FFFF">
-
<td><b>Voice of Baraunians views</b></td><td><%Response.write(Application("visitors"))%></td>
-
</tr>
-
</table><br>
-
-
<%
-
If Not IsEmpty(Request.Form("submit")) then
-
vopenflg = Request.Form("vopenflg")
-
vopenflg=trim(vopenflg)
-
R("open_flg")=vopenflg
-
R.update
-
R.Close
-
conn.close
-
end if
-
next
-
end if
-
%>
-
<table width=765>
-
<tr><td width="60%"></td>
-
<td><input type= "submit" name="submit" value="Apply">
-
<input type="button" name="submit" value="Back" onclick="moderate()">
-
<input type ="button" value="EXIT" onClick="window.close()"></td>
-
</tr>
-
</table>
-
<script language="Javascript">
-
function moderate()
-
{
-
window.location = "moderator1.asp"
-
}
-
</script>
-
</div>
-
</form>
-
</body>
-
</html>
-
hi i am creating a link with topid and display row detail after click i wants to update open_flg value which is selected and store in vopenflg but it is not change so any body help me it update only normal thats value is null cahracter -
<%@language=vbscript%>
-
<%option explicit%>
-
<%
-
If Request.Cookies("userid") = "" Then
-
Response.Redirect "login.asp"
-
Else
-
dim my_conn_stRing, conn,R,R1,R2, sql,Rcount,Rpage,page,i,vopenflg
-
dim stroutput,reply,repcount,stropt1,vtopid,detail
-
MY_CONN_STRING = "dsn=oracle;uid=starter;pwd=starter;"
-
Set Conn = server.createobject("ADODB.Connection")
-
Conn.open MY_CONN_STRING
-
set R = Server.CreateObject("ADODB.Recordset")
-
for each stropt1 in request.QueryString
-
vtopid = request.QueryString(stropt1)
-
R.open "Select top_id,top_sub,MSG,open_flg,launch_by,launch_dt from topmaster where top_id="&vtopid&"",conn, adOpenStatic, adLockOptimistic, adCmdText
-
%>
-
<html>
-
<head><TITLE>Vioce Of Baraunians</TITLE></head>
-
<body bgcolor="#FFFFFF" background="back.jpg">
-
<!--#include file="front.inc"--><br><br>
-
<meta http-equiv="Content-Type" content="text/html; charet=iso-8859-1">
-
<div style="position:absolute; top:100; left:0 ">
-
<table width="1000" border="0" cellspacing="1" cellpadding="3" bgcolor="#663333" >
-
<tr bgcolor="#CCCCFF">
-
<td width="8%" ><b>TOPIC ID</b></td>
-
<td bgcolor="#CCCCFF" colspan="50%"> <b>TOPIC SUBJECT</b></td>
-
<td bgcolor="#CCCCFF" colspan="50%"><b>MESSAGE</b></td>
-
<td bgcolor="#CCCCFF" width="12%"> <b>POSTED BY</b></td>
-
<td bgcolor="#CCCCFF" width="12%"><b>POSTED DATE</b></td>
-
<td bgcolor="#CCCCFF"><b>Permission</b></td>
-
</tr>
-
<tr bgcolor="#FFFFFF">
-
<td bgcolor="#66FF99" width="8%"><%=R("top_id")%></td>
-
<td align="left" colspan="50%" bgcolor="#66FF99"><b><font face="arial" size=2><%Response.Write R("top_sub")%></font></b></td>
-
<td bgcolor="#66FF99" COLSPAN="50%"><%=R("msg")%></td>
-
<td bgcolor="#66FF99" width="12%"><%=R("launch_by")%></td>
-
<td bgcolor="#66FF99" width="12%"><%=R("launch_dt")%></td>
-
<form action="update1.asp" method="post">
-
<%
-
vopenflg=request.Form("vopenflg")
-
dim sqlstr
-
sqlstr = "update topmaster set open_flg = '"&trim(Request.Form("vopenflg"))&"' where top_id = " & vtopid
-
response.Write(vopenflg)
-
conn.execute sqlstr
-
R.close
-
response.redirect("moderator1.asp")
-
conn.close
-
set conn=nothing
-
end if
-
next
-
%><form action="update1.asp" method="post">
-
<td width="10%"><font face="arial" size="2"><b>Apply</b></font>
-
<select name="vopenflg">
-
<%If IsEmpty(vopenflg) Then%>
-
<option value=" ">Normal</option>
-
<option value="0">Absue</option>
-
<option value="1">clsoe</option>
-
<%End If%>
-
</select>
-
</tr>
-
<tr><td>topic id <%response.Write(vtopid)%></td></tr>
-
</table>
-
<table width="1000" border="0" cellspacing="1" cellpadding="3" >
-
<tr align="right" bgcolor="#99FFFF">
-
<td><b>Active user</b></td><td><%Response.write(Application("visitors"))%></td>
-
</tr>
-
</table><br>
-
-
<table width=765>
-
<tr><td width="60%"></td>
-
<td><input type= "submit" value="submit">
-
<input type="button" name="submit" value="Back" onclick="moderate()">
-
<input type ="button" value="EXIT" onClick="window.close()"></td>
-
</tr><tr><td>hello<%response.Write(vopenflg)%></td></tr>
-
</table>
-
<%end if%>
-
<script language="Javascript">
-
function moderate()
-
{
-
window.location = "moderator1.asp"
-
}
-
</script>
-
</form>
-
</div>
-
</body>
-
</html>
-
mistake in line -
<%
-
if request.Form("submit") then
-
%>
-
I merged threads for you. Please do not double-post questions.
Do you have a link to this? Maybe I would understand it better if I could see it.
Also, is this all on one page, or do you have the form and form handler on separate pages?
Jared
Hi jhardman
thanks to reply and understand my question .i got my result the value is losed before updating so the problems is solved. Thanks again becouse project is not completed without help so all guies is help me in completion of my project. i am submitted it today.I am taking more time in small project but one thing is know my bassic is not clear so i try to clear it .thanks to all.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Fan Ruo Xin |
last post by:
I try to copy a table from production system (DB2 UDB EEE V7.2 + fixpak5)
to the testing system (DB2 UDB V8.1 + fixpak4a).
I moved the data from productions system by using the following steps:...
|
by: MikeY |
last post by:
Hi everyone,
I have posted earlier this week, but I'm still scratching my head trying to
figure out how to change/modify my data back to my db.
Using C# Windows forms. I am trying to learn how...
|
by: Henry |
last post by:
Hi. I've been trying to modify my dataset and have been unsucessful. Any
help would be great.
What I have is a dataset in a session variable. Here is what I have done to
stored into the dataset...
|
by: VitorJOL |
last post by:
Hello
I have a listbox with a datasource.I want to remove a row from listbox but
not remove it from the database.
How can i do this ?
PROBLEM:"Cannot modify the Items collection when the...
|
by: muttu2244 |
last post by:
Hi everybody
Am trying to read a csv file "temp.csv", which has the below info,
compName macAddr ipAddr
opSys
|
by: mimasci |
last post by:
Hi,
I have tried to write a code that allowed me to modify the value of
the cells selected in a table, with excel has been easy.
How one approaches selected cells? (To modify the value)
How...
|
by: sklett |
last post by:
I've got a strange situation here. I have a databound DataGridView that
also has un-bound columns. When the view loads, I want to update the values
of the unbound columns. If I attempt to modify...
|
by: Patrick |
last post by:
Hello,
I want to modify an existing XML-File based on Input in a Form.
I used a DataSet to load the XML File with the ReadXml method.
I then displayed the relevant entries via the GetChildRows...
|
by: dfm |
last post by:
Hi, I cant change the header to display images from a database. It's giving me this error :
Warning: Cannot modify header information - headers already sent by (output started at...
|
by: MeoLessi9 |
last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: Aftab Ahmad |
last post by:
Hello Experts!
I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: marcoviolo |
last post by:
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
| |