Syntax error access violation 1104 sql työt
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
Access-tietokanta, joka sisältää tiedon syöttämistä, raportteja ja mahdollisuutta muokata tietoja.
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
...distance in the relevant column. 5. **Google Sheets Setup:** - Create a well-structured and easy-to-navigate Google Sheets document. - Ensure all columns are labeled clearly and the data is sorted correctly. - Share the final document with [Your Email Address]. **Deliverables:** - A Google Sheets document containing the complete cricket schedule. - The sheet must be shared with edit access to [Your Email Address]. **Columns to Include in the Google Sheet:** - Date - Match Number - Teams - Match Format - International or Domestic - UK Start Time - New Zealand Start Time - Stadium Name - City - Distance from Sidcup, UK **Skills Required:** - Proficiency in Google Sheets. - Attention to detail and accuracy in data entry. - Ability to convert time zones. - Basic understa...
...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating adm...
I'm currently in need of an Android app developer with experience in creating educational apps. The app should be designed to deliver high-quality video lessons to users. Key Features: - The primary function of the app should be centered around educational purposes. - The app should provide an intuitive platform for users to access a range of video lessons. I'm looking for a professional who can bring this vision to life. The ideal candidate should have: - A strong understanding of Android development. - Prior experience creating educational applications. - A keen eye for user experience and interface design. - The ability to integrate video lessons into the app effectively. If you have the skills and experience necessary, please get in touch.
...system: This project requires designing a custom PCB controller which will integrate with various elements of the security system for automation. • Incorporation of alarm systems: The controller should easily synchronize with alarm systems, enabling automated responses in case of triggered alerts. • Seamless integration with access control systems: I wish to automate the access system in my shop, hence the PCB controller must be compatible with modern digital access mechanisms. • Door sensor compatibility: The controller should also connect flawlessly with door sensors, to monitor and log the opening and closing activities. The ideal freelancer for this task should have expertise in electronics, PCB design, and have a track record of developing si...
Proposal for Technical Writing Project: Internet Safety for Children Introduction The digital age has brought unprecedented access to information and communication tools, but it also poses significant risks, especially for children. This project aims to develop a comprehensive guide on Internet Safety for Children, addressing the critical need for educating parents, teachers, and children themselves about safe online practices. Project Overview The project will produce a series of technical documents that provide practical advice, safety guidelines, and resources for ensuring children’s safety on the internet. These documents will be designed for various stakeholders, including parents, educators, and children. hope you will this report and proposal well Regards Muhammad Ha...
...and modifications. - Image & Photo Integration: To enhance the tracking process, the app should offer the capability to take photos or add pre-existing images for each box. This visual element will significantly improve item identification and management. Platform & Function: - Cross-Platform Development: The application should be developed for both iOS and Android platforms, ensuring that I can access and utilize it regardless of the device I'm using. - Offline Functionality: The app must support full offline functionality. As I'll be using it in various settings, sometimes without an internet connection, it's crucial that all features are available and operational in offline mode. Ideal Skills & Experience: - Proficiency in Mobile App Development: I...
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
Am doing a project using a simple shell and tube heat exchanger design and I have a problem with Ansys fluent validation. I already drew the shell and tube heat exchanger, simple design. However, the problem is that am unable to get similar results as the actual value when it comes to pressure drop. for flow rate 1 am getting it correct, but mass flow rate 0.5 and...drew the shell and tube heat exchanger, simple design. However, the problem is that am unable to get similar results as the actual value when it comes to pressure drop. for flow rate 1 am getting it correct, but mass flow rate 0.5 and 2 kg/s are different and far from the actual values for the pressure drop of the shell outlet. I need someone that can fix the issue achieve at least 6% or less error compared to the act...
...CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in ident...
I am in need of a skilled freelancer to develop a cloud-based document management system. T...develop a cloud-based document management system. This system will be used within my small team, which consists of less than 10 users. Key Features: - File Storage and Organization: The system needs to allow us to securely store and categorize our text documents. - Document Indexing and Search: It should have an efficient indexing system with a powerful search capability, so we can quickly find and access the necessary files. Ideal Skills and Experience: - Proficiency in cloud-based technologies - Experience in developing document management software - Familiarity with creating systems optimized for small teams Please let me know your relevant experience and how you plan to approach thi...
...formatting and punctuation. - Maintain consistency with the original text and illustrations. - Complete the task within the specified deadline of 1 day. Requirements: - Proficiency in English language and grammar. - Excellent typing speed and accuracy. - Experience in copywriting or transcription preferred. - Attention to detail and ability to maintain consistency with the original content. - Reliable access to a computer with Microsoft Word or compatible software. Payment: 3000 Indian Rupees (INR) Deadline: 1 day from the start of the project. Instructions for Applicants: 1. Submit a proposal outlining your experience and approach to completing the task. 2. Include any relevant samples of previous work, especially if related to transcription or copywriting. 3. Confirm your a...
looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site Too...
I'm seeking an experienced Android developer to create a custom application for educational video distribution. Key Features - The primary objective of this ...custom application for educational video distribution. Key Features - The primary objective of this app is to facilitate the sharing of educational content. - The app should support user-generated content uploads. User Accounts - The app should have different access levels for students accessing the content and teachers who will be uploading content. Experience - Prior experience in developing video sharing platforms is a plus. - Proficiency in Android development is a must. - Experience in handling user accounts and differing access levels is highly preferred. If you think you're suitable for the job,...
I'm seeking an experienced developer who can integrate the TradingView API into a cross-platform mobile app. The app will essentially offer real-time market data and advanced charting features. Key Requirements: - Integration of TradingView API: The core focus of this project is to provide users with access to real-time market data and the ability to perform advanced technical analysis using TradingView's robust charting tools. - We will provide the datafeed with indicators required via web socket , the app will use this data and display a real time live chart on the app. You only need to do this chart on the app. No other funtions required. - Cross-Platform Development: You should have experience in developing cross-platform applications that run smoothly on both iOS an...
I'm in need of a marketing specialist to help with a B2B product marketing project. The main objectives for this campaign are: - Increasing brand awareness - Generating leads - Boosting sales Your focus should be on creating an strategy with clea...deals. Our pioneering Investor Discovery Solution, removes barriers enabling Issuers (private companies and funds) to find the perfect investor match within seconds. Investors can now source the most exciting opportunities whether they are private companies, funds or even other Investors, for their primary and secondary share sales. Financial Advisors and Broker-Dealers can now gain access to issuers and investors from anywhere in the world who are unknown to them, to close their deals faster, or grow their busine...
...assistance. Call Center: Call center integration to handle customer inquiries and support calls. - **Points System**: Customer Loyalty: Implement a points system where customers can earn points on purchases, which can be redeemed for rewards or converted to wallet credit. - **Mobile Apps**: iOS and Android Development: Develop mobile apps for both iOS and Android platforms, ensuring users can access the marketplace via smartphones and tablets. - **Multi-Language Support**: Support for multiple languages, including English and Arabic (RTL), across all platforms. **Key Deliverables:** - A fully functional multi-vendor marketplace platform. - Mobile apps for iOS and Android, supporting the specified menu structure.- - Backend web application for management. - Integration with ...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
My Python script is intended to scrape specific Telegram groups, but it's not functioning as expected. I need a developer to address these issues, described below. - **Issue Description**: The script is crashing when scraping certain Telegram groups, which is likely due to the fact that it's not respecting selections. The error presented is “ AttributeError: 'MessageMediaWebPage' object has no attribute 'document'” I can provide the script if you want to check how it’s working. I am open to a whole new script being made. So long as it functions in a similar way. If not familiar you can view telethon api - **Expected Behavior**: The scraping script is supposed to collect data that matches specific regex patterns. This means that
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm looking for a professional who can...installation could be a mix of fixed and remote installations, so you must have experience with both. Additionally, the system requires security features like encryption of sensitive data, secure remote access, and user authentication. Ideal Skills: - Prior experience in programming POS systems - Proficient in customizing user interfaces - Strong background in real-time inventory management - Knowledge of OS download for Ingenico iwl250 GPRS - Proven experience in installing POS systems remotely and on fixed locations - Expertise in implementing security features like encryption, secure remote access, and user authentication. If you have previous experience in similar projects and possess the skill set mentioned above, I�...
I'm looking for a skilled professional who can meticulously guide me in video call through setting up a VPN using Google Cloud and OpenVPN. The primary aim is to ensure secure remote access to a MySQL database from my Windows laptop. Key requirements: - In-depth knowledge of Google Cloud and OpenVPN - Proven experience in configuring secure VPNs - Expertise in MySQL database security and remote access Your role will be to provide detailed, step-by-step instructions on how to properly configure the VPN to meet my security needs. Please bear in mind that I may require access to the MySQL database from multiple remote locations, but most likely will only need it running from 1 remote laptop - the VPN should be flexible enough to accommodate this added funct...
I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should ...
Description: I require a one-time conversion of my QuickBooks accounts into the iBRXL format, specifically at a summary level. Although I alr...format, there are errors in the current version due to software issues, necessitating resubmission. Requirements: Convert QuickBooks account data to iBRXL format Ensure data is at a summary level Correct any existing errors from the previous software conversion Provide a final, error-free iBRXL file ready for submission Ideal Skills and Experience: Proficiency in QuickBooks and iBRXL format Strong attention to detail and accuracy Experience in data conversion and error correction Ability to deliver a high-quality, error-free file promptly If you have the expertise to perform this conversion and correct the errors, I look forw...
Functionality: Data Collection: Retrieve historical stock data (price and volume) for a given set of stocks from a reliable financial data provider (e.g., Yahoo Finance, Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Pre...and Performance Evaluation: Implement a backtesting module to evaluate the performance of the app's predictions over historical data. Calculate metrics such as accuracy, precision, recall, and return on investment (ROI) to assess the effectiveness of the app. User Interface: Develop a user-friendly interface that allows users to input their stock preferences, view the app's predictions, and access the visualizations. Provide options for users to set up alerts or notifications for when a stock meets their...
...functionality of a website from TypeScript, JavaScript, HTML, and CSS to a Python-based system. The website currently allows users to input a URL for evaluation on its ACT and WCAG compliance. Once evaluated, it highlights any errors and provides recommendations for improvement. The source code is provided. Key Requirements: - Recreate user input URL evaluation - ACT and WCAG compliance checking - Error highlighting - Recommendation provision Design Changes: - Redesign of the website's layout - Improvements to the user interface Design Preferences: - Clean and minimalist design - Modern and trendy elements The source code is available for reference. Ideal candidates should have a solid understanding of web development, particularly in TypeScript, JavaScript, HTML, CSS, a...
I am in need of an experienced hacking professional. I have been detecting suspicious activity on my personal website and mobile number and need assistance. Your main task would be to: - Investigate the specific incidents - Retrieve access logs To successfully accomplish this, you must have: - Prior experience in ethical hacking - Strong background in data investigation - Thorough knowledge of digital forensics As the legal owner of the website and mobile number, I am looking for transparent and ethical work only. Any foul play will not be tolerated. Please place a bid only if you are comfortable with these requirements and can provide a full investigation report.
I require a Zabbix installation on Windows. The process should involve default configuration, so no advanced settings or additional modules are required at this stage. Post-installation, I will need assistance with user setup for a small group. Ideal skills and experience would include: - Strong knowledge in Zabbix - Experience with Windows systems - User set... I will need assistance with user setup for a small group. Ideal skills and experience would include: - Strong knowledge in Zabbix - Experience with Windows systems - User setup and support capabilities in Zabbix environment - Good communication skills to guide non-technical users. Your task will be considered complete when Zabbix is installed and operational, and the user group is able to access and use the software ef...
...firewalls or access lists that limit networks that can connect to networks and zones which host client data 2) Restricted zones or subnets to isolate zones which handle client data 3) A specific "allow" list of clients that may connect to subnets hosting customer data (host to host ACLs) 4) restrict network interfaces on servers or workstations (Which process client data) from being connecting to more than one network at any time 5) encryption as well as data minimization when transferring data between tiers Key Requirements: - Incorporate security measures such as Firewalls, IDS/IPS, WAF, and encryption standards. The network diagram should be designed to prevent and detect potential security breaches effectively. - Implement user access controls, allowing dif...
I'm looking for a skilled developer to help me resolve some bugs in my system and provide ongoing support as needed. Ideal skills and experience include: - Strong experience in bug fixing - Proven success with database issues - Excellent knowledge of system design Expectations: - Implement bug fixes and ma...resolve some bugs in my system and provide ongoing support as needed. Ideal skills and experience include: - Strong experience in bug fixing - Proven success with database issues - Excellent knowledge of system design Expectations: - Implement bug fixes and make suitable modifications to address these issues - Provide ongoing support as needed - Communicate updates and feedback through remote access to my system I'm open to discussing the project further with qu...
I'm in need of a skilled web programmer proficient in HTML/CSS, JavaScript, and PHP to create a comprehensive work tracking portal. I have a very rough semi functional example site attached. This will be hosted on a private server with vpn access from each user so security is not a extreame concern. key functions basic login system allow users to enter daily work time with some notes ; I would like them to be able to edit them after allow users to see a list of all open jobs and be able to click on them to open them and edit as needed client management - need to be able to search existing clients or add new ones as well as view any jobs open or closed for the client. job photo uploads need to be optimized for mobile phones / tablets I would also like to add a map...
I'm in need of a developer to set up user roles in my new spring application like they were in the old struts application. Key Project Details: - Setting up roles: I require the creation of Admin, User,...application. Key Project Details: - Setting up roles: I require the creation of Admin, User, Manager, and Supervisor roles with the same permissions as in the old struts application. - No additional roles: The only additional role needed is 'Supervisor'. I do not require Developer or Guest roles. Ideal Freelancer: - Proficient in Java, particularly Spring Framework. - Proven experience in role-based access control. - Familiarity with legacy system migration. - Good understanding of the Struts framework (for comparison purposes). - Strong communication skills for c...
...to display details - plus the ability to forward an event to a friend - plus the ability to follow an event - the app is currently purchased on a one-off basis. TO BE Mandatory criteria – no final payment until these are met 1. Enable SUBSCRIPTION payment for the app from the apple store – must facilitate the option to enable users to subscribe to a quarterly payment model. This is a must. 2. Error trapping - must be able to fail a call or function without crashing the app 3. All dates are in dd/mm/yyyy 4. The Search function must work across all prizes not just those currently calling 5. The code must be deposited in our github 6. Apple must accept the update 7. All drafts must use a version number on the front screen which are incremented for each version 8. Must u...
...specify which pages, products, and categories to manage, and which information to include in exports. Generate XML or CSV links based on user selection. -Allow users to update specific pieces of collected information across all or selected pages, ensuring data remains current and accurate. 2. Proxy System -Implement a dedicated IP system (proxy system) to avoid server or firewall blocking. 3. Data Access and Export -Allow data export in formats such as CSV, XML, etc. -Ensure data export is compatible with Google Merchant Center and other similar advertising services. 4. User Interface -Provide an interface that allows users to explore scraped content through a hierarchical view. -Ensure the user interface clearly and structurally displays the content of each page. -Provide tools ...
I'm looking for an experienced mobile app developer who can build a feature-rich e-commerce app that will work seamlessly on both Android and iOS. The app will cater to a WordPress-based online shop, ensuring customers have a smooth shopping experience with access to unique features. Key Features & Functionalities: - User Registration & Login: A seamless and secure process for users to create accounts and log in. - Push Notifications: Utilizing notifications to engage with users and keep them updated with the latest offers, deals, and more. - Connected to WordPress Shop: The app should effectively fetch and display product data from the existing WordPress shop, ensuring real-time updates of the product catalog. - Custom Stock Management: Admin should have the capabilit...
