|
Yes.
It is like a local variable in the same function.
Bashar Amin
Sr. Software Engineer
|
|
|
|
|
Try adding a Debug.Print line to output your constructed sql UPDATE statement to the immediate window. You can check to make sure the form values are being incorporated the way you think they are. You can also then copy and paste the actual statement from the immediate window and execute it through the SQL view of an access query. This is a good way to test whether or not there is a problem with the UPDATE statement itself.
|
|
|
|
|
Mike,
Thank you for you valuable suggestion. Debug.print is a good way to troubleshoot software bug. I am still getting the "Type mismatch" error but it is updating the table. So I comment out the error check part for now.
Bashar Amin
Sr. Software Engineer
|
|
|
|
|
Hi Bashar. Wow - that's interesting. So the UPDATE command is successfully executing? AND you are getting a Type Mismatch error on the same line?
Just to see what happens, try changing the line
CurrentDB.Execute strSQL to
dim iResult as integer
iResult = CurrentDB.Execute(strSQL)
|
|
|
|
|
I would guess it is this
codeamin wrote: [Action Item Number] = " Me.Action_Item_Number & "
that is causing your problem. in particular the = " Me.Action_Item_Number & "
You are missing the first &. As far as the query is concerned you are trying to enter the literal string value 'Me.Action_Item_Number &' into a numeric column.
Jon
|
|
|
|
|
Jon,
Good thinking. Here is what I have my code now:
<br />
Dim num as Integer<br />
num = Me.Item_Number<br />
strSQL = "UPDATE [Action Item Table] SET [Action Item Table].ysnActionAssigned = -1 " & _<br />
"WHERE [Item Number] = " & num & ";"<br />
CurrentDB.Execute strSQL<br />
I was still getting a "Type Mismatch" error if I check for error. I comment out the error check as it was updating the [Action Item Table].
Thank's for your help.
Bashar Amin
Sr. Software Engineer
|
|
|
|
|
Hi,
I've a running .NET 2.0 app that connects to DB locally (thru ODBC),
using an entry in connectionStrings section in web.config.
Now I want to connect to a second DB, but adding just
another entry in web.config (see below).
(replaced angle brackets by [])
[connectionStrings]
[add name="My1stDbConn" connectionString="Dsn=FirstDB" providerName="System.Data.Odbc" /]
[add name="My2ndDbConn" connectionString="Dsn=SecondDB" providerName="System.Data.Odbc"/]
[/connectionStrings]
How do I tell my code I wanna use the second entry, instead of first one?
Thanks in advance.
Eugenio
-- modified at 7:12 Thursday 9th February, 2006
|
|
|
|
|
Hi Eugenio. Consider what your connection code looks like for the first connection - you must be identifying it by its name "My1stDbConn" at some point. You would do the same thing to create your second connection - just refer to its name "My2ndDbConn" when pulling connection string values from web.config.
|
|
|
|
|
Hi Everybody,
I wrote code deleting data in Excel file by using OLEDB.
But ADO.NET show error
"Delete data in a linked table is not supported by this ISAM"
Now, I want to delete data in Excel file.
Please help me!!!!
Thanks you
Tran Thai Nam
|
|
|
|
|
To my knowledge, there is no way to delete rows in an Excel spreadsheet through OLEDB. You may need to use interop calls directly to the Excel COM objects to accomplish this.
|
|
|
|
|
I think so. Then I change Delete Command to Update Command (fill null value) in ASP.NET.
UPDATE [SHEET1$] SET F2='1' WHERE F1='1'
But I recieved the error "Operation must use an updateable query". I don't know how to fix this bug.
Please help me!
Thanks
Tran Thai Nam
-- modified at 20:02 Thursday 9th February, 2006
|
|
|
|
|
|
I choose my table key is int type and use identity. I don't know HOw many record it have to corrupt my database? Please help me. If that not good please tell me a better way. Thanks
|
|
|
|
|
I don't know what you mean by "when will my database corrupt"? Do you mean how many rows can you insert before the key has to wrap around? If you are using an int type you have a maximum of 4294967296 unique values.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Hi,
I want my query to exclude all fields that are null and zero length.
This is what I use now:
AND ItemDiscount <> ''
Is there a better way to go?
thanks,
Ron
|
|
|
|
|
myNameIsRon wrote: AND ItemDiscount <> ''
That just excludes the empty string, you also need to exclude the nulls.
AND ItemDiscount <> '' AND ItemDiscount IS NOT NULL
Does this help?
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
|
A small team of software engineers have re-architected the Microsoft .NET Pet Shop application by using Software Tree’s NJDX object-relational mapping (OR-Mapping) technology. Here is the abstract of the project report:
The .NET Pet Shop application is designed to show the .NET best practices for building enterprise n-tier applications. In this ASP.NET based web application, classes are defined to represent domain model objects like products, users, addresses, and orders. These domain model objects are persisted in relational databases (e.g., SQL Server, Oracle) using a data access layer (DAL). The current DAL implementation, which uses raw SQL and low-level database APIs, is pretty hard to understand and maintain This report describes how such a data access layer can be replaced with a much simpler and shorter (35% less lines of code) implementation using NJDX OR-Mapping technology from Software Tree. In addition to greatly simplifying the architecture, the NJDX approach provides greater flexibility and delivers superb performance.
Project Report
Press Release
The full implementation code ships with the NJDX software that is available for a free 30-day evaluation from Software Tree’s web site at http://www.softwaretree.com.
Thank you.
Damodar Periwal
Software Tree, Inc.
Simplify Data Integration
http://www.softwaretree.com
-- modified at 21:50 Wednesday 8th February, 2006
|
|
|
|
|
I need to upgrade our db server and was wondering if anyone had any experience with opteron based processors.
I want to use HP ProLiant DL385 with 2 AMD Opteron 280 processors (Raid 5 and 8GB Ram)
I want to use 64bit version of windows and sql server 2005. (System price around $15,000)
How would this compare to comparable Xeon processor based configuration?
|
|
|
|
|
Hello,
I work with sql express edition which comes with visual studio 2005. I want to upload my database (aspnet.mdf) to my Internet Provider.
I have no idea how I can do that. The provider told me I should create a Backup of my database and send him these file. Now I was looking for an backup option but I cannot find any tool coming with VS which provides this function. Further I also was looking for the Enterprise Manager. But I guess this tool comes only with an other SQL Version.
What can I do to upload my database to my provider in a simple and free cost way?
It would be nice if someone can give me some help.
Chris
|
|
|
|
|
It sounds like your provider wants you to send a copy of the .mdf file that is your sql express database. It is likely your provider uses a full copy of Sql Server 2005 rather than Sql Express and I imagine they would import your .mdf file to their instance of Sql Server.
That saying, make sure you are working this out with your provider and following their instructions.
|
|
|
|
|
No, my provider is not able (or doesn't want) to read only a copy of my database.
They told me I must create a backup of my database. The best way in csv.
They (Provider) also provide a Internet tool which I can create a database new on their Server. But I guess I need first to create a script of my database to handle this.
But how? I tried to find a backup program in the internet. I found one but it doesn't work because a backup plugin in sql express is missing...
Question 1: What must I do and which tool I need (freeware) to create a backup?
Question 2: Is there a possibility to create a script which I can use for the provider's database import tool?
Chris
|
|
|
|
|
Hi Chris. Have you asked your provider how to do this? Many ASP.NET hosting companies I've seen have FAQ's or other documentation on how to copy data from a test database to a production one they host.
The easiest way to copy a complete database from test to production I can think of is to detach the sql server database from the test machine, copy the file to the production server, then attach the file within the production server environment. If that's not possible with your host, then maybe this will help:
http://support.microsoft.com/kb/241397/en-us[^]
|
|
|
|
|
I want to make a software which can create a SQL database from scratch with defined tables. (Difficult: Creating database)
Please give me coding of how to create a simple database with two/three tables and two/three columns (with full details as available in SQL Enterprise Manager >>> Table Design) in each table in VB.NET.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
