zubie

Well put ... and any way isnt all that stuff only theory that was developed in the eighties ... I seem to remember someone saying "64k should be enough for anyone" (Bill Gates) :)

Yeah the crystal reports dates are all dd/mm/yyyy It's an access problem so I am changing my date/time fields to text so that they display correctly and adding another field yyyymmdd for searching. seems to work ... dont you just love all these different date formats ZuBiE

Well I checked all the dates ... I have worked a solution that seems to work for all concerned. I am changing my date/time fields to text so that they display correctly. For searching I am adding another field with the date in the format of YYYYMMDD Well it seems to work OK so I'm leaving it like that .. any DB admin would kill me for not normalizing it correctly :) ZuBiE

Well I need to sort by date What I'm testing now is already in a project and is causing all types of problems

Well I am only testing at the moment My problem is tha even if I use the parameter I'm still getting 25/12/2004 and 12/01/2004 instead of 25/12/2004 and 01/12/2004

Hi All I am using SQL to insert a date into an access table: Regional settings are set to dd/mm/yyyy hh:mm When I insert the following SQL = "insert into DateTest (MyDate, MyTime) values ('25/12/2004', '12:00') I get 25/12/2004 BUT When I insert the following SQL = "insert into DateTest (MyDate, MyTime) values ('01/12/2004', '12:00') I get 12/01/2004 anyone know why this happens?? cheers ZuBiE

Hi All My project is on a server off site. Regional setting have the date as dd/mm/yyyy In my access db I have date/time fields defined as dd/MM/yyyy When I display my data in a crystal report however verything is displayed as mm/dd/yyyy anyone know why this is happening? cheers ZuBiE

well blow me over with a feather ... I got it ... In Access you can use the * as a wild card and it works fine BUT in .net you have to use % Man but that wrecked my head!!! later ZuBiE

Hi All I'm still trying to figure out why like doesnt work when used in ASP.NET Anyone out there know why?

strSql = "SELECT Customers.CustomerCode, Customers.CustomerName, Customers.Addr1, Customers.Addr2, Customers.Addr3, Customers.Addr4, Groups.GroupName, Reps.RepName, Territories.TerritoryName, Customers.AttentionOf, Customers.PhoneNo " & _ "FROM (Groups RIGHT JOIN (Customers LEFT JOIN Reps ON Customers.RepNo = Reps.RepCode) ON Groups.GroupCode = Customers.GroupCode) LEFT JOIN Territories ON Reps.TerritoryNo = Territories.TerritoryNo " strSql = strSql & "WHERE Customers.AttentionOf Like '*" & strSearch & "*'" in this case strSearch is "Murp"

OK I tried that, it works fine in Access but when I execute it from .net it isnt returning any rows? any ideas why?

how do I use that in a select statement? I am using the SQL to fill a dataset to pass back

Hi there I need some SQL for Access that will find a string within a string e.g Find "Murp" in "Dr Eugene Murphys Surgery" thanks ZuBiE

Excellent .. thats exactly what I was looking for .. cheers ZuBiE

I looked up truncate in the help (vb.net) and all I got was Int and Fix. Both these round the number up and down I only want to round down

Hi All In vb.net 8 mod 5 returns 3 (the remainder) The calc I require is one that returns the 1 my code at the moment returns 2 on the above calc. intBonus = cint(8/5) Can anyone help here? cheers ZuBiE

Cheers ... I'll look into that thanks for the help ZuBiE

Here is the full error. As I said before this is using the EXACT same code as the first successful run .. *shrug* System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at MARTWS.wsGlobal.ExecuteSql(String strSql) at MARTWS.Report.ReportParameters(String strDateFrom, String strDateTo, Int32 intDaysSuspended, Int32 intDaysAbsent) at MARTWS.wsReports.WriteReportParameters(String strDateFrom, String strDateTo, Int32 intDaysSuspended, Int32 intDaysAbsent) --- End of inner exception stack trace --- Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at MARTWS.wsGlobal.ExecuteSql(String strSql) at MARTWS.Report.ReportParameters(String strDateFrom, String strDateTo, Int32 intDaysSuspended, Int32 intDaysAbsent) at MARTWS.wsReports.WriteReportParameters(String strDateFrom, String strDateTo, Int32 intDaysSuspended, Int32 intDaysAbsent) --- End of inner exception stack trace --- Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [soapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at MARTWS.wsGlobal.ExecuteSql(String strSql) at MARTWS.Report.ReportParameters(String strDateFrom, String strDateTo, Int32 intDaysSuspended, Int32 intDaysAbsent) at MARTWS.wsReports.WriteReportParameters(String strDateFrom, String strDateTo, Int32 intDaysSuspended, Int32 intDaysAbsent) --- End of inner exception stack trace ---] System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1489 System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218 ProjectMART.wrReports.wsReports.WriteReportParameters(String strDateFrom, String strDateTo, Int32 intDaysSuspended, Int32 intDaysAbsent) +130 ProjectMART.ReportChoice.btnViewReport_Click(Object sender, EventArgs e) +645 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Nope ... It worked fine the first time through then tried to run the same report again and it bombed out at the .ExecuteNonQuery

OK I'll give it a shot and get back to ya

OK Here is a update SQL Public strConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Inetpub\wwwroot\MART\db\MART.mdb" strSql = "update ReportDetails set DateFrom = '" & strDateFrom & _ "', DateTo = '" & strDateTo & "', DaysSuspended = " & _ intDaysSuspended & ", DaysAbsent = " & intDaysAbsent ExecuteSql(strSql) This call the function ExecuteSql Friend Function ExecuteSql(ByVal strSql As String) 'Use this function for updates, inserts and deletes Dim clsConnection As New Connection() Dim dbconConnection As System.Data.IDbConnection = New OleDbConnection(strConnectionString) Dim cmdCommand As New OleDbCommand(strSql, dbconConnection) Try 'Open connection dbconConnection.Open() 'Execute the Sql cmdCommand.ExecuteNonQuery() Catch ex As Exception Throw ex Finally dbconConnection.Close() End Try End Function

Ahhh ...... Well maybe I dont have all the correct permissions. What permission do I have to give for the DB The big problem is that this works once fine (reads/writes to the DB) and then gives the error!!!!!

Hey all I have an ASP.net 1.1 project running on Server 2003 Problem: 1) First time I run page on the server it is fine. (eg add a user) 2) If I try and run something else (eg add/amend user) I recieve an error message saying "operation must use an updateable query" (It seems to have kept a lock on the DB) The DB has all the required permissions. The app runs perfectly on the development machine with no locking problems anyone every experience this? any help gladly recieved ZuBiE

Hey again Well I have VS 2002 .. I'm happy with it and its working grand I do however have a problem with my server I have a screen for adding/amending users This works fine so my Web services seem to be working when I try and run a screen with a CrystalReportsViewer on it I recieve an error "Error executing child request for repViewer.aspx" anyone got any ideas? have I missed anything in my install package? cheers ZuBiE

Hi all My project is written using .net 1.0. I have .net 1.0 and .net 1.1 installed on the server how can I be sure that my 1.0 project is reading the correct framework Also if I want to change my project from 1.0 to 1.1 what is the best way of doing this? cheers ZuBiE