Comments by _Damian S_ (Top 126 by date)

You have dumped a mass of code here, but haven't asked a question. What is it that you specifically need help with? Perhaps just that snippet of code is all you need to post?

select Prod.pdt_name as ProductName, SimProdLeft.pdt_name as SimProdNameLeft, SimProdRight.pdt_name as SimProdNameRight
from tbl_pdt Prod
left join tbl_similar_pdt SimProdLeftJoin on Prod.pdt_id = SimProdLeftJoin.pdt_id
left join tbl_pdt SimProdLeft on SimProdLeftJoin.pdt_id = SimProdLeft.pdt_id
left join tbl_similar_pdt SimProdRightJoin on Prod.pdt_id = SimProdRightJoin.sim_pdt_id
left join tbl_pdt SimProdRight on SimProdRightJoin.sim_pdt_id = SimProdRight.pdt_id

It's all about aliasing your tables - that way you can call the same table multiple times.

It's traditional to tell us specifically what your small issue is, including any error messages you may be receiving.

Words can be alphabeticised... if it needs to be in a particular order, you could somehow work out that order and then do a min from that calculated field... eg:

select ID, min(case Status when 'A' then 1 else 2 end)...

private sub Calculate()
' Check that fields are filled as required

' do fancy stuff

' update whatever
end sub

Then inside your click event, simply call "Calculate()".

Here are a bunch of links to check out: http://www.codeproject.com/Questions/310729/Crystal-reports-using-sql-query

Sounds like you want different reports for each table, but to have them display in a CR viewer control or similar... that's pretty easy to achieve, simply by doing a select case statement to see which table you have selected, and opening the appropriate report.

Do your tables relate to each other in any way? If they don't, why are they on the same report? If they do, use a join to link the two tables, eg: select FIELDLIST from TABLE1 inner join TABLE2 on FIELD1=FIELD2

If it's the same code that gets fired, put the common code into a function/procedure and call that from each event - that way your code that actually does the work is in one location, but called from a variety of places.

If you output the returned value of "ds.tables[0].rows[0]["carimage"].tostring();" to a message box, an alert, to the console, whatever... what is the result?

My solution above wasn't to be taken literally, it was the way to go about it with the correct tables. Clearly you need to list all tables and their fields that appear in the result set, otherwise we can only give our best guess rather than an actual solution. Post the full set of tables that the fields in the result set come from.

If your query is returning the correct data, then all you need to do is stash the returned value in the text box. There seems to be some information missing...

No, I have understood what you are asking. If they are already logged in, use similar code to the login page redirect behind the button on the various information capture pages.

Of course the redirect goes to the login - you need them to login I would assume!

If that's not what you want, and you want them to be logged in at the point of signing up, simply include similar code behind your signup page such that they are redirected as necessary... You have the code there already.

So what's the problem? The code is a bit ugly, but looks like it would do what you are after... what happens when you run it? Is it giving you the results you expected?

You have given a single line of code without any description of the problem you are having - what is the error? What happens on the screen? Where does your code fail?

Noone is going to simply give you code. You need to show what you have tried, and where you are stuck.

Don't be shy... feel free to narrow down the line that you are receiving the error on...

That's a bit disappointing then!! Basically you are looking to change the "submit on enter" behaviour. You can use a bit of javascript to catch the enter key and ignore it if that will help...

I agree... just my quirky sense of humour as by the time I read your reply and voted, you had voted mine.

hehe... it's the mutual 5's admiration society...

Exactly!! +5.

Sounds like a good way to go about it... what's the issue?

Difficult for us to guess at what might be occurring without seeing your code...

Which part do you not understand? That was pretty much step by step.

The first part of your SP is where the parameters are. The rest is broken into two almost identical parts - the bits in the if-then-else. As I said above, the first part is used if a value is passed into the @StatusID parameter.

One last time. Any parameters in your stored procedure need to be passed a value, either through your code, or by setting a default value. It doesn't matter if you use them or not inside the SP, but you must pass them a value if they are in the parameter list.

Use the ones that are valid for each update statement, ignore the rest.

I have been attempting to help you all afternoon, however you seem to either not understand what I have told you, or are not able to implement it. I'm sorry, but I have a meeting to go to now, so hopefully someone else can help you from here.

Please tell me they aren't your real ftp details (site, user, password)? If they are, I suggest you remove them and replace them with made up data. Also, having your email address as your username is likely to result in an increased amount of spam.

If your table doesn't have a name column, you can't use it in an update statement.

If your stored procedure has a parameter called @name, you must provide a value for it in your code (or give it a default value in your SP).

These two things are completely unrelated, and must both be attended to.

As an aside, you have a typo in the word nvarchar above.

ROFL... you asked for code!! ;-)

I've given you the answers... which part isn't working now?

That's not the same as your code above... you now have @name in the update statement, so will need it in the parameter list, therefore need to pass it into the stored procedure.

You aren't updating it... it doesn't appear anywhere in your SP apart from the parameter list...

You aren't passing a value for @name. Either remove it from the stored procedure, or give it a default value eg: NULL. Alternatively, pass it a null value in your code:

cmd.Parameters.Add("@name", dbnull.value)

cmd.Parameters.Add("@weight", SqlDbType.Float).Value = cdbl(TextBox6.Text.Trim())

These lines:
cmd.Parameters.Add("@weight", SqlDbType.Float).Value = TextBox6.Text.Trim()
cmd.Parameters.Add("@dt", SqlDbType.DateTime).Value = DateTimePicker1.Text.Trim()

@weight is expecting a float to be passed, not a string. @dt is expecting a date/time.

Remove @name from your stored procedure, or give it a default value of NULL.

What's your question?

Two different solutions for the OP to choose from!!

Very nice solution using select top(1)... have a 5 on me!!

Your current code doesn't really do anything... is there some code missing?

In that instance, the solution might fall under Option 2 above... alternatively, you could run the reports after hours and stash the data in a temp table for querying, with the data refreshed nightly.

File-->Save As-->CSV??

Full details here: https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files

Is it a Windows Update error that you are experiencing? More information required...

I'm not going to click on a random link... update your post with relevant information.

http://msdn.microsoft.com/en-us/library/System.Data.DataTable.Select.aspx

Where are you getting the modulecode for the where clause from? On a form? From the user?

We need a bunch more information here... What actually happens when you run your program? Does it compile? Can you step through the code?

It wasn't a search for clarification... I was pointing the OP in the likely direction of his error... I prefer to guide people towards the answer rather than simply handing it to them on a plate.

Your exec sp... has the parameters in the wrong order. They need to match the order specified in the parameter list.

You aren't using the correct connection string for windows authentication. Check out www.connectionstrings.com

Not quite... you need to call rptPrintToPrinter(1, False, 0, 0) after each setting of the printer, otherwise it will just print to the last one you set.

You can't have two printers on the same system with the same name... Use the two different names, even if they are the same type of printer...

Both printers need to be available to the system printing the order. Use the same code you already have (that you said was working), but replace the printer name with the name of the second printer.

No worries... job well done!!

Yes, that would work. Link via Organisation_ID and Projects.Organisation_ID.

Why do you want to store the persons age in the database rather than their date of birth?

:-D No worries.

You haven't completely followed the advice I gave you... You are only half way there. If your syntax was correct, you wouldn't have the error!! ;-)

Here's what you missed:

insert into userdetails(Name,DOB,Addr,phn,Country,States,City)
values(@Name, @DOB, @Addr, @phn, @Country, @States, @City)

Sergey gave you an answer... I think both of you have struggled to get your points across. Telling someone to be quiet isn't helping.

I think you might have to use the actual value, rather than a parameter... give it a try...

You should put this as a solution so I can award you some points. ;-)

Have updated solution based on your further information.

Not sure what your question is... could you please rephrase.

I've updated my answer above.

Are you wanting to only delete items from FamilyMember, or from another table also?

How to do what? Do you have an exe that selects the messages and sends them to the user mobile? If so, simply schedule a task in your server to fire off the exe file on the schedule you desire. Google "scheduling a task in " + your version of windows.

It's best not to enter your whole question in the subject field - it makes it quite difficult to read.

Okay, so the question is, what's in CustDetail table for the id you are looking to delete... for instance, do they have a linked record in CustOrders or CustAddress (examples - your table names will vary)?

How could the average possibly be 373.4? The sum (total) might be that, but not the average.

Did you read the article? What you have described in your question is precisely what replication exists for.

It wasn't in your question when I posted my answer.

The other option is to either attach your code to the ASP process through tools-->Attach to Process, or do it the old fashioned way by writing a log or sending an email to yourself at critical points in the system so you can see where it falls over.

Yes, that's exactly what I'm saying. You do it with a separate application. Instead of opening your application directly (the one that the users need to have updated), have them open your CheckVersion application (or something similar), which either grabs the latest version then opens it, or simply opens the existing version.

No, it was addressed to the OP, who has since deleted his post, which makes it seem as though it is a reply to you.

Where is the data coming from? This is less a regex issue and more like a data issue. Parsing really bad data will yield reasonable results if it follows one of several formats, but completely random text is almost impossible to deal with.

Are you stuck with the data coming through however it comes, or can you enforce better data entry at another point in the system to make your life easier?

For that little outburst, there shall be no further help for you from me. The answer I gave you above showed you how to retrieve the first 50 chars... I won't be doing all your work for you, but pointing you in the right direction so that you can actually learn something. Don't you dare tell me I've wasted YOUR time...

Well, which specific part are you stuck on? Does your ASP.NET site display info from the database? Does your gprs device insert records into the database?

Yes, I just updated my answer...

So which table has the record in it?

Well, what's happening in view1? Could you perhaps make view2 that isn't as complex and use that?

You have several issues here.

1. Why the Attendance Machine sometimes works and sometimes not.
2. How to share data with a remote server.
3. Having to do some work first to show what you have tried and where you are getting stuck.

In its current format, this question does not have enough information for us to provide much help.

Well of course you can't insert the same record twice - and the error message gives you the answer... Is one of the fields you are trying to insert the Primary Key? (Or several fields together forming a composite primary key.) If so, you will need to use different test data each time.

It looks like some of your SP is missing, but that's alright, if you say it added a couple of records then stopped, it's obviously working. For the ones where it didn't work, was there something different? A NULL where a value is expected? A foreign key that isn't right? Data integrity faults? Trying to insert a duplicate into a primary key field? These are common things that will cause your SP to fail sometimes...

I don't think too many people are willing to click on a random link to who-knows-what... perhaps you can update your question with further information that doesn't require the clicking of a random link.

No. You cannot use the stored procedure taUpdateCreateItemRcd to do an insert, as there is no insert code in it.

You could, however, complete your new SP SD_InsertInventoryItem by including an insert statement where you have execute dbo.taUpdateCreateItemRcd.

This is exactly what would happen... Your browser will first check if there's a page in the cache that is the page you are navigating to, then it will display it. There are exactly issues as you describe (requiring a CTRL-F5) on here from time to time - particularly after Chris and the hamsters roll out a new version...

As I said above, either in a new SP, or create the SQL in a variable and execute that rather than a SP.

No. Your stored procedure is wrong. Your only other option would be to get a new stored procedure created (preferable), or create a string representation of your SQL and execute that (bad idea due to leaving you open to a SQL injection attack).

You have the following in your SP:

GO
/****** Object: StoredProcedure [dbo].[taUpdateCreateItemRcd] Script Date: 05/02/2013 15:44:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[taUpdateCreateItemRcd] @I_vITEMNMBR char(30), @I_vITEMDESC char(100), @I_vITMSHNAM char(15), @I_vITMGEDSC char(10), @I_vITMCLSCD char(10), @I_vITEMTYPE smallint, @I_vVCTNMTHD smallint, @I_vTAXOPTNS smallint, @I_vITMTSHID char(15), @I_vUOMSCHDL char(10), @I_vITEMSHWT numeric(8,2), @I_vTCC char(30), @I_vCNTRYORGN char(6), @I_vDECPLQTY smallint, @I_vDECPLCUR smallint, @I_vPurchase_Tax_Options smallint, @I_vPurchase_Item_Tax_Schedu char(15), @I_vSTNDCOST numeric(19,5), @I_vCURRCOST numeric(19,5), @I_vLISTPRCE numeric(19,5), @I_vNOTETEXT varchar(8000), @I_vALTITEM1 char(30), @I_vALTITEM2 char(30), @I_vITMTRKOP smallint, @I_vLOTTYPE char(10), @I_vLOTEXPWARN tinyint, @I_vLOTEXPWARNDAYS smallint, @I_vINCLUDEINDP tinyint, @I_vMINSHELF1 smallint, @I_vMINSHELF2 smallint, @I_vALWBKORD tinyint, @I_vWRNTYDYS smallint, @I_vABCCODE smallint, @I_vUSCATVLS_1 char(10), @I_vUSCATVLS_2 char(10), @I_vUSCATVLS_3 char(10), @I_vUSCATVLS_4 char(10), @I_vUSCATVLS_5 char(10), @I_vUSCATVLS_6 char(10), @I_vKPCALHST tinyint, @I_vKPERHIST tinyint, @I_vKPTRXHST tinyint, @I_vKPDSTHST tinyint, @I_vIVIVACTNUMST varchar(75), @I_vIVIVOFACTNUMST varchar(75), @I_vIVCOGSACTNUMST varchar(75), @I_vIVSLSACTNUMST varchar(75), @I_vIVSLDSACTNUMST varchar(75), @I_vIVSLRNACTNUMST varchar(75), @I_vIVINUSACTNUMST varchar(75), @I_vIVINSVACTNUMST varchar(75), @I_vIVDMGACTNUMST varchar(75), @I_vIVVARACTNUMST varchar(75), @I_vDPSHPACTNUMST varchar(75), @I_vPURPVACTNUMST varchar(75), @I_vUPPVACTNUMST varchar(75), @I_vIVRETACTNUMST varchar(75), @I_vASMVRACTNUMST varchar(75), @I_vKTACCTSR smallint, @I_vPRCHSUOM char(8), @I_vRevalue_Inventory tinyint, @I_vTolerance_Percentage numeric(19,2), @I_vLOCNCODE char(10), @I_vPRICMTHD smallint, @I_vPriceGroup char(10), @I_vUseItemClass tinyint, @I_vUpdateIfExists tinyint, @I_vRequesterTrx smallint, @I_vUSRDEFND1 char(50), @I_vUSRDEFND2 char(50), @I_vUSRDEFND3 char(50), @I_vUSRDEFND4 varchar(8000), @I_vUSRDEFND5 varchar(8000), @O_iErrorState int output, @oErrString varchar(255) output as set nocount on select @O_iErrorState = 0 return (@O_iErrorState)

Just before the last part where it says select @O_iErrorState = 0 return is where you need to put an insert statement like this:

insert into TABLENAME(FIELD1, FIELD2, ... , FIELDLAST) values (@PARAM1, @PARAM2, ... , @PARAMLAST)

Sorry, I don't have VB6 available any more, so I can't assist further.

You need to ask an actual question. What are you trying to do? Get the value in Answer? Is that something like table1.value2 multiplied by the Value from Table2 for each ID in table1.Value1?

You should have a crystal report variable, that you assign the value to. eg:

Dim crDoc As CrystalDecisions.CrystalReports.Engine.ReportClass
set crDoc = new CRpeminjaman

Oops... missed a line... have added above. Need to set the crDoc to your Crystal Report that you are wanting to open.

You will also need to actually open the Crystal Report at some point, but I've not included that as it isn't relevant to adding parameters.

Where are you defining CRpeminjaman? I assume it's a crystal report within your system?

I see... I think you might underestimate the complexity of developing such a product... Personally I'd use one of the browsers already in the marketplace - if for no other reason than they have teams of people keeping on top of things such as security issues etc... Good luck with it though!!

What do you mean by restricted count? Do you want to limit it to a particular number of concurrent users? Or are you meaning security related, ie: you only want authenticated users to access your system?

Set a breakpoint in your code towards the top of your sub, then run your program. Step through the code one line at a time until you locate the line that is causing the error.

Why? Sounds like you are way out of your depth here... what exactly are you wanting to create a new web browser for?

No, the insert statement goes inside your Stored Procedure. That's why you are passing all the parameters in...

This bit here: "\InfoDB.accdb"";Jet OLEDB:Database Password=adminGMRT;" will result in the following string: \InfoDB.accdb";Jet OLEDB:Database Password=adminGMRT;

See the extra " after accdb and before ;?

You want to use this: "\InfoDB.accdb;Jet OLEDB:Database Password=adminGMRT;"

You probably need to include the form submission code rather than the appsettings...

Why? I don't want your application adjusting my computer's settings, and I'm pretty sure noone else does either...

Sadly, you will need to do it like my example if you are wanting it to turn out like your question above... It's important to use the same number of fields in the same order for each table!!

No, it's alright... I usually give enough information to let the other person have a crack at it themselves rather than a full solution...

Of course it is - that's the else part. The value is not '', it's NULL. NULL and '' are different.

Yes there, reread my solution - it's the path through the menus to the Site Bugs and Suggestions forum...

Ummm... this is exactly the same information I provided... Look at the menu above... Discussions-->Site Bugs and Suggestions is the way to get to this forum.

The point I am making is that you need to have a business rule that you can consistently apply to handle these situations. Without that rule to apply, you can't proceed past that point.

How are you handling the instance where he has entered twice but not exited between? ie: Rows 3 and 4.

Is your code doing something silly like creating the table each time it's called?

Here's an article on it... http://www.codeproject.com/KB/dotnet/config.aspx

Inside the On Click event, you could use something similar to the following:

docmd.runsql "Update TABLE2 set FIELDNAME = " & me.COMBONAME & " where FIELDID = " & me.FIELDID

Clearly you need to use correct field and table names, and this assumes you have some kind of identifier to do this...

What are you actually trying to achieve, as this does seem a little convoluted...

What kind of validation are you wanting to do? Why not use a validator to do it for you?

I would suggest if you can't open and read through a text file using vb.net, creating a C file checker is going to be too difficult for you at this stage. Perhaps start by learning the basics.

as TotalAmount means give the field name TotalAmount, so if your have it in your query, your DataReader line should work.

Every time you run an SQL statement on a table, it is calculated at that point in time, so if you run it now, then change your data and then run it again, the value will change.

Are you sure you mean adding a new page at design time? By definition you can add new things at design time - you are designing!! Do you mean adding a new page at runtime instead?

I removed your email for two reasons. 1. Including your email will allow email harvesters to grab it and spam you till the end of time. 2. Emailed replies don't help other people who may have the same problem, whereas someone adding an answer here will.

You say that you want the last character to be removed, but what if the cursor is in the middle of the text somewhere? Would you not want it removed where the cursor is situated?

How have you gone about doing this?

I don't have a copy of the library... I was simply giving you the general solution to a problem such as yours. Try google, and search for cgzipfiles download.