Categories
Apple User Help

Quick search in NAS. Which software for overview?

We use a NAS in our small company to acces our files from different locatins. Searching within the NAS does not work well due to the amout of data stored and slow internet connection. So if we’re looking for a file, we need to know exactly where it is. Is there a way to keep […]

Categories
Database Development

Cleaning replication tables before snapshot applied to subscriber

We have a snapshot replication setup. In some cases (like previous replications failed etc), some subscribers get the following error The ALTER TABLE statement conflicted with the FOREIGN KEY constraint “<FK_constraint>”. The conflict occurred in database “”, table “”, column ‘’. (Source: MSSQLServer, Error number: 547) I found out that executing following clean up SQL […]

Categories
CMS Joomla Mastering Development

Adding a module from a component

I have a component that I want to use to add a module automatically. This needs to be achieved in the administrator area. My idea is to have a button in one of the component views. That component will make an ajax call which will then automatically create a module. I have the ajax working […]

Categories
Mastering Development

SQLite : Where with multiple conditions and index

I am facing some troubles with indexing my SQLite database. Background : I have databases that can be query on each columns, all are TEXT COLLATE NOCASE, all conditions are “LIKE ***%”, the database is in no case sensitive like, the page size is 32768 My databases are read only, i fill them up one […]

Categories
Mastering Development

Using Node.js to generate dynamic word document using Database value

I am trying to dynamically populate the WORD Document using npm docx. I am trying to read the data from the SQLite database but due to async node js property the values are not getting into the variable and it shows undefined. If I make the function synchronous the npm docx throws error and doesn’t […]

Categories
Mastering Development

Error 1064 (42000) while creating a stored procedure in MySQL

I am getting the following error while trying to create a stored procedure. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘NULL’ at line 1. This is my code: DELIMITER $ CREATE PROCEDURE CRT_TBL(IN tablename […]

Categories
Mastering Development

Subsetting, Matrices

I am super new to R and currently playing with the “diamond” dataset. I am trying to return the row corresponding to the lowest, mean and largest prices and put everything in a 10 by 4 matrix. Please explain an easier way of doing this if possible. library(ggplot2) data(diamonds) min(diamonds$price) mean(diamonds$price) max(diamonds$price) # this one […]

Categories
Mastering Development

Auto-HTML tags completion in C#

i’ve been trying to implement a Auto-HTML tags feature in a Winforms Richtextbox. I’m a beginner in C# and i needed a reference so i’ve come across this article on CodeProject. With this given code: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace AutoCompleteHTMLTags_CSharp { public partial class […]

Categories
Mastering Development

How do I search a table that is created with javascript

I have a table that is created by javascript when it obtains data from the data base, this is the function function gotCData(snapshot){ snapshot.forEach(userSnapshot => { var confirmed = userSnapshot.val().confirmed; var date = userSnapshot.val().date; var deaths = userSnapshot.val().deaths; var recovered = userSnapshot.val().recovered; //console.log(confirmed, date, deaths, recovered); var local = k; var csvDate = date; var […]

Categories
Mastering Development

How can i add a button on each row in a table in CODENAME ONE?

the question is :How can i add a button on each row in a table in CODENAME ONE? and as u can see in the line 19 i commented where the code should be to add a button inside col4 Form hi = new Form(“Table”, new BorderLayout()); TableModel model = new DefaultTableModel(new String[] {“Col 1”, […]